In this project, you are assigned to design, organize and implement a REMS 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 > The de 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 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. o 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 of any exist. At the end of this project, you will submit a report that contains the following items: A brief description and assumptions about tables and relations, ER Diagram (your design should contain at least 8 tables), Relational Data Model, Data Definition Language Details (DDL), including all necessary constraints, . - Data Manipulation Language (OML) Normalization Steps (upto 3NF). 15 queries retrieving statistical information to help management (use the functions/methods you learned, such as join, subauery, group by, to char etc.) These are the minimal requirements which means they have to be implemented, but Implementing only the requirements that is mentioned above will not be enough to get full mark. You should extend this design and create a rete database using MySQL or any other database program You can prepare your project on your own or in a group of two maximum. Queries as well as ther outputs must be provided with screenshots In this project, you are assigned to design, organize and implement a REMS 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 > The de 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 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. o 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 of any exist. At the end of this project, you will submit a report that contains the following items: A brief description and assumptions about tables and relations, ER Diagram (your design should contain at least 8 tables), Relational Data Model, Data Definition Language Details (DDL), including all necessary constraints, . - Data Manipulation Language (OML) Normalization Steps (upto 3NF). 15 queries retrieving statistical information to help management (use the functions/methods you learned, such as join, subauery, group by, to char etc.) These are the minimal requirements which means they have to be implemented, but Implementing only the requirements that is mentioned above will not be enough to get full mark. You should extend this design and create a rete database using MySQL or any other database program You can prepare your project on your own or in a group of two maximum. Queries as well as ther outputs must be provided with screenshots
