Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

select a business case and run through the project exercises. You can select one case from below case list or can propose a different case.

select a business case and run through the project exercises. You can select one case from below case list or can propose a different case.

CASES Database for a Customer Complain Management System Database for a Warehouse and Inventory Management System Database for a Social Media Website Database for a Human Resources Department Database for a Stock Trading Platform Database for a Content Streaming Website Database for a Ride-sharing App

Requirement and Conceptual Modelling 80 points

List of requirements for the database.

Be sure to include 8 to 10 entity descriptions with all required attributes and relationship with cardinality descriptions. While listing the entities, attributes, and cardinalities, try to demonstrate your understanding about different types of entities (not mandatory, use only if applicable), different types of attributes, and different types of relationships (not mandatory, use only if appropriate) 40 points

Entity Relationship Diagram based on the list of requirements. The ERD should be created using ERDplus tool. 40 points

Logical Modelling and Implementation 20 points

Databases Schema Relationship Diagram. The schema should be created using ERDplus tool. 10 points

Database Creation MySQL Statement. Be sure to appropriately modify the datatypes. I only want the codes pasted in the word document. The code should be created using ERDplus tool. I will run the code on MySQL to check accuracy. 10 points

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Emerald Handbook On Cryptoassets Investment Opportunities And Challenges

Authors: H. Kent Baker, Hugo Benedetti, Ehsan Nikbakht, Sean Stein Smith

1st Edition

1804553212, 978-1804553213

More Books

Students also viewed these Finance questions