Database Design : Take a crack at designing a simple database for ‘A Small Denti

Question

Database Design : Take a crack at designing a simple database for ‘A Small Dentist Office’. To keep it simple, please exclude any financial or billing information. So build a simple database that keeps track of patient information and appointments. Keep this very simple, maybe 4 tables.

Part I: First determine the entities. The entities will be the tables. For example in an employee database the entities might be: an Employee, a Dept. These would then become the tables….the Employee table and the Dept table.   Once you have come up with your 4 tables, move on to Part II.

Part II: Design each table. Tables must include:

Appropriate column names

Data type for each column

Whether a column can be ‘null’ or not

Indicate any ‘Primary Keys’ and ‘Foreign Keys’.

Indicate any relationships with other tables

Explanation / Answer

Answer:

Part 1:Entities
Patient

Dentist

Appointment

Problem_detected

Part 2:Tables

1.Patient

2. Dentist

3.Appointment

4. Problem_detected

Relationships:

1:1 relationship between Patient and Appointment

1:1 relationship between Dentist and Appointment

1:N relationship between Patient and Problem_Detected

Field name Data types PK/FK NULL/NOT NULL patientid int PK NOT NULL name varchar(128) NOT NULL address varchar(128) NOT NULL phone numeric(10) NOT NULL email varchar(128) NULL

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.