100%(1)100% found this document useful (1 vote) 600 views4 pagesCS403 Assignment
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content,
claim it here.
Available Formats
Download as PDF or read online on Scribd
Virtual University
< Total marks = 20
fe nment No.1 Solution Deadline |
Semester: Spring 2024 29% of April 2024
refull the folk
Don't copy-paste the same answer.
Make sure you can make some changes to your solution file before submitting
copy paste solution will be marked zero.
Ifyou found any mistake then correct yourself and inform me.
Before submitting an Assignment GDB checks your assignment requirement file.
For any query, feel free to Contact at
WhatsA pp: +923074960034
Provide by MJUNAID QAZI
Imagine you are asked to design a database for a famous online bookstore. The bookstore sells a variety of
books across different genres and authors. Customers can browse the bookstore's website, search for books, add
them to their shopping carts, and proceed to purchase them. The database should store information about books
authors, genres, customers, orders, and order details. Each book has a unique ISBN (International Standard
Book Number), title, publication year, price, and quantity instock. Each author has a unique author ID, name|
and biography. Books can be categorized into multiple genres (@.@., fiction, non-fiction, science fiction, arts
literature, etc.).
Customers can create accounts on the website, with each customer having.a unique customer ID, name, emai
address, and shipping address. Customers can add books to their shopping carts and proceed to checkout
place orders. Orders are associated with customers and contain information such as order ID, order date, and
total price.
Each order can include multiple books, with details such as the quantity of each book ordered and the price a
the time of purchase.
CONTACT ON WHATSAPP
+923074960034 Task No. 01
‘© Draw a Context Level Data Flow Diagram (DFD) of the given bookstore system.
Book inventry
CONTACT ON WHATSAPP
+923074960034 ‘Task No2:
Identify all possible entities and their attributes in the given system.
Extract all relationships among the entities.
Draw a comprehensive Entity Relationship Diagram (ERD) of the given bookstore system showing all entities
their attributes, and relationships among entities that you have identified.
Your ERD must show all minimum and maximum cardinalities clearly.
CONTACT ON WHATSAPP
+923074960034 Every Assignment/GDB is change due to unique Student ID so don’t copy
That is truly perfect step hy step idea solution get help easily.
Wish you the very best of Luck!
CONTACT ON WHATSAPP
+923074960034
