Question

Question 7 – Data Design Bundoora College has a small book store that opens for students, staff and general public. Currently, they use a manual order system. The manager asked you to build a database for them. You had an interview session with him and you get a general overview about the database requirements. The database should store: • Orders information made by students, staff or general public. The order should have order number, the date and the time it is made. • Customers details, so that the manager can notify the customers with the order status as well as send promotional material. The detail includes customer code, the full name, home address, contact phone number, and email address. • List of the items in each order. The items can be books and/or stationeries. For each book, you should be able to include the details such as the title, the authors, the ISBN, and the price. For stationery, you should have the code, description, and price. • If a book is required for a particular subject offered in Bundoora College, the database should store this data as well. The information includes the subject code, the subject name, the coordinator name, and the semester it is offered.

a) Create an Entity-Relationship Diagram (ERD) for the bookstore database. Make sure you include all required entities, relationships and cardinalities information. [15 marks]

b) Create the table design (schema) for the database. You should indicate clearly the primary and foreign keys for each table. [10 marks]

c) During which phase of the SDLC is ERD used? [5 marks]

Answer 1

Thank you. Please give an upvote. If any queries or changes needed please comment will respond ASAP!!!!