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. (1). Create an Entity-Relationship Diagram (ERD) for the bookstore database. Make sure you include all required entities, relationships and cardinalities information.

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter2: Database Design Fundamentals

Section: Chapter Questions

Problem 11RQ

See similar textbooks

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.

(1). Create an Entity-Relationship Diagram (ERD) for the bookstore database. Make sure you include all required entities, relationships and cardinalities information.
(2). Create the table design for the database. You should indicate clearly the primary and foreign keys for each table.

Expert Solution

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

(1). Create an Entity-Relationship Diagram (ERD) for the bookstore database. Make sure you include all required entities, relationships and cardinalities information. (2). Create the table design for the database. You should indicate clearly the primary and foreign keys for each table.

(1). Create an Entity-Relationship Diagram (ERD) for the bookstore database. Make sure you include all required entities, relationships and cardinalities information.
(2). Create the table design for the database. You should indicate clearly the primary and foreign keys for each table.