Question: Part 2 - Database Implementation Step 1 : Examine the Relational Schema that was created during the Part 1 of the project. Step 2 :

Part 2- Database Implementation Step 1: Examine the Relational Schema that was created during the Part 1 of the project. Step 2: Based on that schema, create a set of tables for using a DBMS (such as MS Access, SQL Server Express, or My SQL). Name the database and its tables appropriately. Make sure to specify primary keys for all tables. Make sure all referential integrity constraints are enforced. Step 3: Create all the necessary relationships between the tables. Step 4: Populate the tables with initial data (no less than two no more than ten records per table). Step 5: Create a front-end interface containing several forms and reports of your choice for the created database. The set of requirements will be Hospital have many doctors. Hospital have many nurses. Doctors diagnose many patients. Patients undergo many tests.
2.
3 The relational schema that can be derived from the ERD is, Hospital(Name,location)
Doctor(ID,Name,specialization)
Nurses(No,Name,Doctor)
Patients(I,Id?() Name,Doctor)
Tests(ID, Name, charge)
TestsOnPatients(TestID, PatientID, Date, Doctor)
The mapping is shown below Based off the relational schema in oicture please follow the directions above which is part 2 and send a screenshot and file as well
 Part 2- Database Implementation Step 1: Examine the Relational Schema that

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!