A production company consists of a machining, fabrication and assembly department. Employees are assigned to different departments. Each department is managed by a manager. Each Employee has at most one recognized skill, but a given skill may be possessed by several employees. An employee is able to operate a given machine-type(e.g. lathe, grinder, welding) of each department. Some of the employees are paid overtime and some of them are paid with daily basis. According to their designation(e.g. mechanic, welder) are supposed to maintain at least one machine-type of their department. Raw materials are bought from different vendors and fetched to the machining department. Parts from machining department are fetched to fabrication department and so on. Many parts are assembled together to form a product. The final products from assembly department together to form a product. The final products are stored in the ware house. Products are labeled with different specifications(e.g. Product_Id, product_type, MRP, etc). Your design should include an E-R diagram, a set of relational schemas, and a list of constraints, including primary-key and foreign-key constraints.
A production company consists of a machining, fabrication and
assembly department. Employees are assigned to different
departments. Each department is managed by a manager. Each
Employee has at most one recognized skill, but a given skill may be
possessed by several employees. An employee is able to operate a
given machine-type(e.g. lathe, grinder, welding) of each department.
Some of the employees are paid overtime and some of them are paid
with daily basis. According to their designation(e.g.
are supposed to maintain at least one machine-type of their
department. Raw materials are bought from different vendors and
fetched to the machining department. Parts from machining
department are fetched to fabrication department and so on. Many
parts are assembled together to form a product. The final products
from assembly department together to form a product. The final
products are stored in the ware house. Products are labeled with
different specifications(e.g. Product_Id, product_type, MRP, etc).
Your design should include an E-R diagram, a set of relational schemas,
and a list of constraints, including primary-key and foreign-key constraints.
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 1 images
