Create a database of your choice that contains. use SQL server management studio : At least 3 normalized tables At least 3 queries Create and ER diagram of the database with relationships indicated....

1 answer below »

Create a database of your choice that contains. use SQL server management studio :



  1. At least 3 normalized tables

  2. At least 3 queries

  3. Create and ER diagram of the database with relationships indicated.

  4. Create a user manual that I can use to work with the database.

Answered 1 days AfterMay 08, 2021

Answer To: Create a database of your choice that contains. use SQL server management studio : At least 3...

Aniket answered on May 09 2021
144 Votes
ER.PNG
MANUAL.docx
MANUAL
DATABASE
The Database SAMPLETest contains three tables. Doctor, Test a
nd Patient.
TABLES
DOCTOR TABLE
Doctor Table contains the information about the Doctor. It has following attributes – Doctor ID, Doctor Name, Phone Number, Doctor Charges and Specialization. Here Doctor ID is the primary key.
TEST TABLE
Test table contains the information about Test conducted in the hospital. It has following attributes –
Test ID, Test Name, Test Description, Test Charges. Here Test ID is the primary key.
PATIENT TABLE
Patient Table contains the information about the patient in hospital. It has following attributes –
Patient ID, Patient Name, Gender, Age, Symptoms, Phone Number, Doctor ID, Test ID.
Here Patient ID is the...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here