Question
Database System An online bookstore asks you to design a database to keep track of customer transaction. The rules are A customer can buy many
Database System
An online bookstore asks you to design a database to keep track of customer transaction. The rules are
A customer can buy many books
A book can be bought by many customers
Some Customers do not buy any book.
Some book is never bought.
List existence-dependententity________________________
List existence-independententity________________________
Please design a database model (using Crows foot notation) for this online bookstore.
(Assume that CUSTOMER has the following attribute: CUS_NUM, CUS_NAME, CUS_EMAIL)
BOOK has the following attribute: BOOK_CODE, BOOK_COPY , BOOK_TITLE, ISBN)
CUSTOMER(CUS_NUM, CUS_NAME, CUS_EMAIL)
BOOK(BOOK_CODE, BOOK_COPY , BOOK_TITLE, ISBN)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
SQL Database Programming
Authors: Chris Fehily
1st Edition
1937842312, 978-1937842314
