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.