Answered step by step
Verified Expert Solution
Question
1 Approved Answer
create a full project with ERD by using these information.Do not forget to create all 7 tables that i mention on picture . Please ,
create a full project with ERD by using these information.Do not forget to create all tables that i mention on picture Please create tables and add values Write all ddl statements that i write below. Create a full project with ERD by using these information will be working on Oracle Database APEX Blood Donation System Database Project A system in which data of patient, data of donor, data of blood bank would be saved and will be interrelation with each other. Data of Patient Patient Name, Patient Id Patient Blood Group, Patent Disease. Data of Donar Donar Name, Donar Id Donar Bood Group, Donar Medical report, Donar Address, Donar Contact number. Data of Blood Bank Blood Bank Name, Blood Bank Address, Blood bank Donor's name, Blood Bank Contact Number, Blood Bank Address. Try to implement such scenario in a database, create a schema for it an ER diagram for it and try to normalize it must be these tables If you want you can add more tables and entities. Tables: Patients, Donors, BloodBanks, Doctors, Bloodinventory, Blood test, Hospital. Try to implement such a senerio in a database, create a schema for it an ER diagram for it and try to normalize it Dont forget to create all tables that i mention in picture. Required Items for Project Detail of the scenario Developing ERD Defining at least Entity Defining attributes Defining all necessary relationships Identify with matrix diagram If possible superypesubtype, arc and hierarchical structures, nontransferable relationship. Preparing "table instance chart" to map ERD to DB structure Writing SQL DDL statements for implementing ERD create table, constraints, defining keys: and Making Physical Database using APEX Entering data to the Database Writing SQL DML Statements to reach information One statement including subquery One statement including join One statement including group by One statement including date function One statement including character function One statement including update One statement including alter table
create a full project with ERD by using these information.Do not forget to create all tables that i mention on picture Please create tables and add values Write all ddl statements that i write below.
Create a full project with ERD by using these information will be working on Oracle Database APEX
Blood Donation System Database Project
A system in which data of patient, data of donor, data of blood bank would be saved and will be interrelation with each other.
Data of Patient Patient Name, Patient Id Patient Blood Group, Patent Disease.
Data of Donar Donar Name, Donar Id Donar Bood Group, Donar Medical report,
Donar Address, Donar Contact number.
Data of Blood Bank Blood Bank Name, Blood Bank Address, Blood bank Donor's name, Blood Bank Contact Number, Blood Bank Address.
Try to implement such scenario in a database, create a schema for it an ER diagram for it and try to normalize it
must be these tables If you want you can add more tables and entities.
Tables: Patients, Donors, BloodBanks, Doctors, Bloodinventory, Blood test, Hospital.
Try to implement such a senerio in a database, create a schema for it an ER diagram for it and try to normalize it Dont forget to create all tables that i mention in picture.
Required Items for Project
Detail of the scenario
Developing ERD
Defining at least Entity
Defining attributes
Defining all necessary relationships Identify with matrix diagram
If possible superypesubtype, arc and hierarchical structures, nontransferable relationship.
Preparing "table instance chart" to map ERD to DB structure
Writing SQL DDL statements for implementing ERD create table, constraints, defining keys: and
Making Physical Database using APEX
Entering data to the Database
Writing SQL DML Statements to reach information
One statement including subquery
One statement including join
One statement including group by
One statement including date function
One statement including character function
One statement including update
One statement including alter table
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started