Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

In this project, you are assigned to design, organize and implement a RDBMS for Toy Story that will store, manipulate and retrieve all airport related

image text in transcribedimage text in transcribed

In this project, you are assigned to design, organize and implement a RDBMS for Toy Story that will store, manipulate and retrieve all airport related information. The database you will design will organize the information about all the toys as supplied materials, production, sale etc. as well as: The DB should store detailed information about the Customers who can either be a wholesaler or a retailer. The Customers should also be able to make Orders for a particular Product/Products that are taken by the employees. The employees at the company can be a manager or a normal employee When an order is made the particular toys (product) have to be produced in Production Depending on the product being produced certain raw materials must be obtained In order to obtain the raw materials, suppliers need to supply the materials o The attributes of each entity must be specified such as (name, customer_id, contact details etc.) for the customers table. If the customer is a wholesaler you need to store the maximum capacity that they can hold, if they are a retailer you should store the number of retail outlets they have. The cardinalities must also be mapped out after establishing the relationships that exist such as a customer being able to make many orders or many suppliers being able to supply raw materials, by doing this you also need to outline your weak entities if any exist. At the end of this project, you will submit a report that contains the following items: Relational Data Model, Data Definition Language Details (DDL), including all necessary constraints, . Data Manipulation Language (DML), Normalization Steps (upto 3NF), 15 queries retrieving statistical information to help management (use the functions/methods you learned, such as join, subquery, group by, to_char etc.)

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

Graph Databases In Action

Authors: Dave Bechberger, Josh Perryman

1st Edition

1617296376, 978-1617296376

More Books

Students also viewed these Databases questions

Question

What is the basis for Security Concerns in Cloud Computing?

Answered: 1 week ago

Question

Describe the three main Cloud Computing Environments.

Answered: 1 week ago