In groups of 3 or 4, you will design a database management system for a fictional business. You will write a report which must propose an entity relationship diagram (ERD) model and subsequent logical design.
The physical database implementation for the proposed model should be developed with MySQL. You will also present your design to the class.
|1.00pm Wednesday, Week 10
|For the report: Use 12 pt font
|Double-space your document to allow room for feedback State all your names and student numbers in the document header. State the word count on the cover page of your report.
|Include a bibliography at the end of your report.
|APA referencing style.
|Complete and submit a peer and self-evaluation form.
|PDF file (.pdf) or Word (.doc) only for the project report PDF file (.pdf) or Word (.doc) only for the peer and self- evaluation form PDF file (.pdf) or PowerPoint (.ppxt) only for the presentation SQL statements in a text file or as SQL script (.sql)
Online shopping management system:
An online shopping system is a type of electronic commerce that allows customers to buy goods or services over the Internet. It is done via a web browser or a mobile app.
To design and implement the database for online shopping system, you have to consider the following things:
Each customer does multiple transactions, and each transaction is done by only one customer. Each customer does multiple payment, and each payment is done by only one customer. Each payment has multiple transaction reports and each transaction report have only one payment.
Each shopping order has multiple transaction reports, and each transaction is related to only one shopping order. Each customer can order multiple times and each shopping order is done by only one customer.
Each customer has multiple deliveries, and each delivery is related to only one customer. Each order is related to one delivery and vice versa.
Each product can be delivered multiple times and each delivery is related to only one product. Each product can have multiple sellers and each seller can have multiple products. Each product can have multiple transaction reports and each transaction is related to only one product.
In the ERD, you have to identify all entities, relationship, and cardinalities and provide the reasonable attributes (where necessary) including primary keys and foreign keys.
(Note you have to insert data into your tables at least 10 rows in each table.)
After creating your ERD and implementing the database design, you must prepare a presentation for the business development manager to discuss the ERD and database
In your presentation, enlighten the business development manager on the future of database system and how this online shopping system can benefit from future trends such as NoSQL, big data, data mining, data warehouse, and business intelligence.
Given the future trends, you also need to discuss the importance of implementing database security management, backup and recovery management.