Using the relations that you defined and normalized as part of the unit 4 assign
ID: 3916902 • Letter: U
Question
Using the relations that you defined and normalized as part of the unit 4 assignment (attached below), create the SQL DML statements necessary to implement your database schema as an OpenOffice database.
Your assignment must include a document that contains all of the SQL statements and a screen shot that shows the structures that you implemented in the database of your choice. Your DML statements must accommodate the following elements:
Create statements to create tables from the entities defined as part of the Unit 4 assignment
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
Assignment Instructions:
the assignment must include the SQL DML statements required to implement at least the following relations:
Book
Borrower
BookLended
Librarian
the assignment must 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.
the assignment must 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.
the assignment must make appropriate use of keys including the automatic generation of key values where appropriate.
Relations:
Explanation / Answer
As the questions does not clearly state what answer is expected.
For DML statements you can use SELECT, INSERT, UPDATE, DELETE, MERGE on the tables however maintaining integrity constraint.
ex. SELECT B.TITLE , C.PUBLICATIONDATE FROM BOOK B, BOOKCOPY C WHERE B.ISBN_NUMBER = C.ISBN_NUMBER.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.