Create an Entity-Relationship (E-R) model for a new company that recently started a business where they buy highly discounted items in bulk from different companies who are going out of business or need to get rid of additional items to save warehouse space. This new company has retail stores in big cities across the country where they sell the items to individuals. They also do business as wholesalers where they sell items in bulk to local retailers in small cities. Therefore, they have two types of customers: individuals and small retailers. The company has four departments: purchase, warehouse, sales (retail and wholesale) and accounting. They employ five different types of employees: managers, accounting staffs, warehouse staffs, retail associates, and purchase agents. Each staff, agent and associate works under a manager of the respective department. Purchase agents hunt for discount items, and they get a commission based on the items they are successfully able to buy. You have freedom to make necessary assumptions about relations and attributes to create a realistic model. However, you must incorporate at least one composite and one multivalued attribute in the model. In the design, identify all primary keys and mapping cardinalities correctly. If any of the relation schema representing a relationship set is redundant, remove that. Mention your justifications. After removing redundancies, for each relation schema list a reasonable set of functional dependencies that should exist.
Create an Entity-Relationship (E-R) model for a new company that recently started a business where they buy highly discounted items in bulk from different companies who are going out of business or need to get rid of additional items to save warehouse space. This new company has retail stores in big cities across the country where they sell the items to individuals. They also do business as wholesalers where they sell items in bulk to local retailers in small cities. Therefore, they have two types of customers: individuals and small retailers. The company has four departments: purchase, warehouse, sales (retail and wholesale) and accounting. They employ five different types of employees: managers, accounting staffs, warehouse staffs, retail associates, and purchase agents. Each staff, agent and associate works under a manager of the respective department. Purchase agents hunt for discount items, and they get a commission based on the items they are successfully able to buy. You have freedom to make necessary assumptions about relations and attributes to create a realistic model. However, you must incorporate at least one composite and one multivalued attribute in the model.
In the design, identify all primary keys and mapping cardinalities correctly.
If any of the relation schema representing a relationship set is redundant, remove that. Mention your justifications.
After removing redundancies, for each relation schema list a reasonable set of functional dependencies that should exist.
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 1 images
