Database homework done in 1HR
dennoh kithinji
hw14.docxIEE 305, Homework#1
HW1 should be submitted on the course blackboard by the due time indicated in the syllabus.
1. (5 points) Chapter 5, Exercise 1
2. (5 points) Chapter 5, Exercise 3
3. (40 points) Give one E-R model for Chapter 5, Exercises 5 – 8.
Note: Exercises 5 – 8 cover different parts of an E-R model. For problem 3, only one E-R model needs to be submitted for covering all parts of the E-R model from Exercises 5 – 8. The list of 1-10 on the top of Page 77 is a list of queries which tell you how users will use this database, you read the queries to verify whether or not data in your E-R model provide sufficient information to answer these queries, but you do not need to do queries; exercises 6-8 are at the bottom of Page 77.
· The complete E-R model in an E-R diagram
· Any assumptions that you make and anything else that you think helps explain, clarify and validate your E-R model.
The description of the database application project is provided below. For the project, students need information in the project description from the beginning to the end of the Queries section. To develop the E-R model for the project, students need to read information from the beginning of the project description to the end of the Queries section in order to determine what data need to be represented in the E-R model. Students cannot design the queries in the Queries section at this stage, but should read the list of queries to determine what data need to be included in the E-R model.
