Now GoBook still using manual management system to maintain the sales and purchase transactions. You are asked to create a database system that can store data and maintain the sales and purchase transactions. The tasks that you must do are: a. Create Entity Relationship Diagram to maintain sales and purchase transactions. b. Create a database system using DDL syntax that relevant with sales and purchase transactions. c. Create query using DML syntax to simulate the transactions process for sales and purchase transactions. and only for ERD.
GoBook
GoBook is a books store located in London. The owner wants to manage easily and record all activities that belongs to GoBook like selling books to customer and purchasing new book from vendor.
To improve GoBook’s management, The owner hired you as a
Every staff that hired by GoBook have a task to serve a customer who wants to buy a book and purchase book from vendor. Every staff must be following the procedures to become a staff, which are:
- Every staff hired must have a personal information like name, gender, date of birth, address, email, phone number, and salary.
- Staff can purchase book(s) from vendor to restock the book stock.
- Every purchase transaction made with the vendor have all the information about staff, vendor, purchase date, book(s) purchased, and the quantity of each book.
- Every vendor that wants to sell their book must completed their information like name, address, email, phone number.
- Vendor can sell more than one book in a transaction.
- Every book purchased from vendor have information like name, purchase price, sales price, and stock.
- Every book has its own book category data that have information like name.
- Staff can also serve a customer who wants to buy book(s).
- Every sales transaction made by the customer have all the information about staff, customer, sales date, book(s) sold, and the quantity of each book.
- Every customer that wants to purchase a book must already completed personal information like name, gender, date of birth, address, email, and phone number.
- Customer can purchase more than one book in a transaction.
Now GoBook still using manual management system to maintain the sales and purchase transactions. You are asked to create a database system that can store data and maintain the sales and purchase transactions. The tasks that you must do are:
a. Create Entity Relationship Diagram to maintain sales and purchase transactions.
b. Create a database system using DDL syntax that relevant with sales and purchase transactions.
c. Create query using DML syntax to simulate the transactions process for sales and purchase transactions.
and only for ERD.
Step by step
Solved in 2 steps with 1 images