Database Architecture and Programming

Database Architecture and Programming
Instruction:
Create an ER model to represent the data use by the library.
The library provides books to borrowers. Each book is described by title, edition and year of publication and is uniquely identified using the ISBN. Each borrower is described by his or her name and address and is uniquely identified using a borrower number. The library provides one or more copies of each book and each copy is uniquely identified using a copy number, status indicating if the book is available for loan and the allowable loan period for a given copy. A borrower may loan one or many books and the date each book is loaned out and is returned is recorded. Loan number uniquely identifies each book loan.
Thing to submit:
1. E-R diagram
2. Each relationship needs to be noted with multiplicities and directions.
Step 2: Convert E-R diagram to relational Schema
Instruction:
Convert the E-R diagram in Step 1 to be relational schema.
Thing to submit:
1. Word document that describes the relational schema

Step 3: SQL statements to implement the relational schema
Instruction:
Write out the SQL statements to implement the relational schema.
Thing to submit:
1. Submit a word document that contains SQL statements for implementing the above relational schema.

Order from us and get better grades. We are the service you have been looking for.