Question: Course Learning Outcomes Evaluated in this Assignment - Develop a data model given a set of business requirements Instructions The following is a description of

 Course Learning Outcomes Evaluated in this Assignment - Develop a data

Course Learning Outcomes Evaluated in this Assignment - Develop a data model given a set of business requirements Instructions The following is a description of the business that will be used to develop a software application. You must create an entity relationship diagram to describe the data requirements of the system. The Business The client is going to automate the inventory of their bookstore. This inventory management system is eventually going to be connected to their sales system, but that is outside the scope of this exercise. Here is the description of the data: - Each book is identified by a unique ISBN number. You can assume that this is a world-wide unique number. - Each book can have one or more authors - Each book can have only one publisher - The following information about each book is tracked: ISBN, author(s), title, category, publisher and suggested retail price - The following information about each author is tracked: Name, email address - The following information about each publisher is tracked: Name, contact name, contact email address - You may add other data components as you see fit Specific instructions: 1. You may use any tool you like to create the ERD. You may even choose to draw it by hand. 2. Submit the ERD as a .pdf file. (If drawing it by hand, you may take a picture and past it into a document, then save it as a .pdf file. 3. Choose the properties that you feel are necessary for each entity. May sure they appear on the diagram. 4. Choose a key for each entity. Make sure you identify it with the correct drawing convention

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!