Solved by Expert Tutors
Solved by Expert Tutors
Question

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

Step-by-step answer

s ante, dapibus a molestie consequat, ultrices ac

congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui

Answer.docx
sum dolor sit amet, con rem ipsum dolor sit m ipsum do pulvin a mo ur laoreet. Nam risu gue vel m ipsum do Fusce s a m o. Donec aliquet. Lorem ipsum lestie consequat, ultrice ipisci , cons ultric

Subscribe 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.

  • -

    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
Let our 24/7 Computer Science tutors help you get unstuck! Ask your first question.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes