Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started