View the step-by-step solution to:

Database Analysis and Design This bookstore needs to keep data and information in an organized manner so as to be able perform calculations and make...

Good Evening,

I was wondering if I could get some assistance with this Computer Science concept. Thank you in advance for the help!

Database Analysis and Design This bookstore needs to keep data and informa±on in an organized manner so as to be able perform calcula±ons and make decisions that are based on a well analyzed and factual informa±on. The data that would help in designing the new database will be found from the following sources: Interviews with management Viewing of receipts Invoices The excel Fles Order documents Transac±ons ²inancial reports Given the above documents. The database system will have the following en±±es and a³ributes as well as data types. The bookstore will have the following en±±es given the informa±on above. Book Cashier Customer Publisher Order Payment Supplier EnTTes and their A±ributes CustID int CustName varchar Contact varchar Order orderId int (PK) ProdID int (FK) CustID int Qty Decimal Product ProdID int ProdName varcha r ProdType int(²K) PubID int(FK) AuthID int(FK) Price decimal Cashier CashierID int CashierName varchar Contact varchar Publisher PubID int (PK) AuthID int (FK) BookID int Publisher_Name varchar
Background image of page 1
OrderDate Date ProdType ProdID int DescripTon varchar ±he above table structures shows how the tables will efecTvely store inFormaTon and assist in simpliFying calculaTons as well as producing reports. ±he customer table will store details oF all customers that do business with the organizaTon. ±his helps in tracking customers For markeTng and to be able to give goods on credit. ±here is also inFormaTon on cashiers and suppliers to be able to trace who authorized a parTcular transacTon and to be able to ²nd suppliers easily, in case oF complaints or even to order For more products. All reports will be generated by using ad hoc queries that will join enTTes and retrieve the needed inFormaTon. ±he design has also captured possible growth in the Future where the company may decide to add more products apart From books and CDs by introducing the Prod±ype to store all inFormaTon about the products and be reFerenced in case a transacTon is done. Improving Database Design Through En±ty-Rela±onship Modeling ±he purpose oF this SLP assignment is to re²ne database design using ER modeling principles. You are required to conTnue working on the project started in the previous SLP and do the Following: 1. IdenTFy all relevant enTTes and relaTonships. 2. Use ER diagrams to present them. Payment ±ransID int PK custID int (FK) trans±ype varchar amount Decimal Date Date Cashier int (FK) Supplier SupplierID int Supply±ype varchar Contact varchar City varcha r Email varchar
Background image of page 2
Show entire document
Sign up to view the entire interaction

Top Answer

View the full answer
Answer.docx

Entities and Attributes
Supplier SupplierID
SupplyType
Contact
City
Email Product ProdID
ProdName
ProdTypeID
BookID
Price
SupplierID ProdType ProdTypeID
Description Order OrderID
ProdID
CustID
Qty...

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online