Using the relations that I attached, defined and normalized, create the SQL DDL statements necessary to implement database schema as an OpenOffice database. You may also implement your database in MySQL, IBM DB2 Express, Microsoft Access, SQL Server if you have access to these database systems. The answer should include a document that contains all of the SQL statements that you created and a screenshot that shows the structures that you implemented in the database of your choice. Your DDL statements must accommodate the following elements: Create statements to create tables from the entities defined as part of the attachment. Appropriate use of Null (and Not Null) parameters to ensure data validity Appropriate use of constraint clauses to implement appropriate referential integrity Use of data types and formats that is appropriate for the data in your database schema. Appropriate use of keys including automatic generation of key values if appropriate Shoulkd include: * the SQL DDL statements required to implement at least the following relations: Doctor Patient Appointment Specialty PatientMedicine Medicine PatientAllergy Allergy make appropriate use of Null (and Not Null) parameters to ensure data validity. The minimum standard will be measured against the instructor’s example and will be based upon rules associated with primary and foreign keys and integrity constraint rules. make appropriate use of constraint clauses to ensure the referential integrity of the relations in the schema. The minimum standard will be measured against the instructor’s example and will be based upon rules associated with primary and foreign keys and integrity constraint rules. NOTE: the unary relationship that we defined for the Doctor relation is NOT required as part of this assignment. make appropriate use of keys including the automatic generation of key values where appropriate.

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

Using the relations that I attached, defined and normalized, create the SQL DDL statements necessary to implement database schema as an OpenOffice database. You may also implement your database in MySQL, IBM DB2 Express, Microsoft Access, SQL Server if you have access to these database systems. The answer should include a document that contains all of the SQL statements that you created and a screenshot that shows the structures that you implemented in the database of your choice. Your DDL statements must accommodate the following elements:

Create statements to create tables from the entities defined as part of the attachment.
Appropriate use of Null (and Not Null) parameters to ensure data validity
Appropriate use of constraint clauses to implement appropriate referential integrity
Use of data types and formats that is appropriate for the data in your database schema.
Appropriate use of keys including automatic generation of key values if appropriate

Shoulkd include:

* the SQL DDL statements required to implement at least the following relations:

- Doctor
- Patient
- Appointment
- Specialty
- PatientMedicine
- Medicine
- PatientAllergy
- Allergy
make appropriate use of Null (and Not Null) parameters to ensure data validity. The minimum standard will be measured against the instructor’s example and will be based upon rules associated with primary and foreign keys and integrity constraint rules.
make appropriate use of constraint clauses to ensure the referential integrity of the relations in the schema. The minimum standard will be measured against the instructor’s example and will be based upon rules associated with primary and foreign keys and integrity constraint rules. NOTE: the unary relationship that we defined for the Doctor relation is NOT required as part of this assignment.
make appropriate use of keys including the automatic generation of key values where appropriate.