Chapter #7 Database Management System Using the following Doctors, Patients, app

Question

Chapter #7 Database Management System Using the following Doctors, Patients, appointment and rooms

Create Tables and Constraints In this unit, you will work with your group to design and implement tables in a DBMS. Do the tables and non-key fields accurately reflect the data model? Are the data types appropriate? Do the primary keys make sense and guarantee uniqueness? Do foreign keys represent all relationships properly? Are all needed constraints specified and appropriate? Are the tables in third normal form? Use the SQL Command Line utility to create the table structures and constraints as agreed. Capture a copy of the SQL commands for the group report. Verify that the database you created represents all of the entities, attributes, and relationships from your group's data model. Correct as necessary. Assemble the group's final list of SQL commands and a list of the table structures into a Word document. Attach and identify the individual candidate data type and constraint lists.

Explanation / Answer

As per the above questions we have created Data MOdel which can discribe how to crate a table and insert data into table.

We have to create 4 table's which is below :

1) Doctors

2)Patients

3)Appointment

4)Rooms

How to create tables are below :

create table Doctor(Dname varchar2(15),Did number(2) primary key,D_department varchar2(10));

create table Patients(Pname varchar2(15),Pid number(2),Pdisease varchar2(15),p_department varchar2(10) foreign key);

create table Appointment(Atime date);

create table Rooms(rid number(2));

In the above table you can insert data as per your requirement's.

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

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