Integrated Case
Gary Cooper (yes - that is his real name,and his nickname is Coop)loves classic cars,but he knows he will never be able to afford most of them.He also knows that most classics are unreliable and expensive to own.Plus,they do not have the features and comforts of modern cars.So,he created a company that constructs custom replicas of classic cars.His replicas have modern mechanical parts and many of the features that can be found in today's cars.More importantly,they meet modern safety and emission requirements.This case describes Coop's sales and production processes.
Coop's Cars: Coop developed a list of replicas for the most sought-after classic cars.He sells replica European Sports Cars,such as Porsche,Ferrari,and Jaguar,as well as some American muscle cars.Coop tracks each car,engine,and color combination with a custom car product number.The customer gets to select among the various engine and color options for his/her car.Customers typically order one car (one product number),but some customers love the cars so much that they order several at once.Customers must provide at least a 25% deposit with the order,but they can pay the balance after they take delivery of the car.
Car chassis: Coop maintains an inventory of car chassis with body shells,interior,seats,etc.Consequently,he can deliver a custom car in just a few days.When the inventory of car chassis gets low,an employee issues a chassis production order.The chassis assembly plan describes the specific parts that go into each chassis as well as the specific chassis assembly operations required.Coop's employees then conduct the assembly operations to assemble the new chassis.
Customizing: After the customer places an order and selects the chassis,engine,and color combination,Coop's employees start the customizing operations.The engine is placed in the car and the car is painted.Then,after some initial testing,the car is placed in inventory,ready for delivery to the customer.Although several employees work on the customizing operations,Coop also designates one employee to supervise the process and assure a high quality finished car.
Miscellaneous: Coop keeps all his employee records in one table,but he also categorizes employees according to their specialty.He records information about employees,customers,employee types,custom cars,and classic parts before they are linked to other classes.
REQUIRED: 1)use the information above and the list of attributes below to draw a UML class diagram showing the classes,associations,and multiplicities,2)prepare a listing of the tables necessary to support Coop's processes using all the attributes.Name each table and clearly identify primary keys with PK and foreign keys with FK.List your tables in the following order: RESOURCES,EVENTS,AGENTS,TYPE IMAGES,and LINKING.Use only the following list of attributes (remember that there should be no classes without attributes).
Attributes

Question

Quizplus · Accepted Answer

The Answer of Integrated Case
Gary Cooper (yes - that is his real name,and his nickname is Coop)loves classic cars,but he knows he will never be able to afford most of them.He also knows that most classics are unreliable and expensive to own.Plus,they do not have the features and comforts of modern cars.So,he created a company that constructs custom replicas of classic cars.His replicas have modern mechanical parts and many of the features that can be found in today's cars.More importantly,they meet modern safety and emission requirements.This case describes Coop's sales and production processes.
Coop's Cars: Coop developed a list of replicas for the most sought-after classic cars.He sells replica European Sports Cars,such as Porsche,Ferrari,and Jaguar,as well as some American muscle cars.Coop tracks each car,engine,and color combination with a custom car product number.The customer gets to select among the various engine and color options for his/her car.Customers typically order one car (one product number),but some customers love the cars so much that they order several at once.Customers must provide at least a 25% deposit with the order,but they can pay the balance after they take delivery of the car.
Car chassis: Coop maintains an inventory of car chassis with body shells,interior,seats,etc.Consequently,he can deliver a custom car in just a few days.When the inventory of car chassis gets low,an employee issues a chassis production order.The chassis assembly plan describes the specific parts that go into each chassis as well as the specific chassis assembly operations required.Coop's employees then conduct the assembly operations to assemble the new chassis.
Customizing: After the customer places an order and selects the chassis,engine,and color combination,Coop's employees start the customizing operations.The engine is placed in the car and the car is painted.Then,after some initial testing,the car is placed in inventory,ready for delivery to the customer.Although several employees work on the customizing operations,Coop also designates one employee to supervise the process and assure a high quality finished car.
Miscellaneous: Coop keeps all his employee records in one table,but he also categorizes employees according to their specialty.He records information about employees,customers,employee types,custom cars,and classic parts before they are linked to other classes.
REQUIRED: 1)use the information above and the list of attributes below to draw a UML class diagram showing the classes,associations,and multiplicities,2)prepare a listing of the tables necessary to support Coop's processes using all the attributes.Name each table and clearly identify primary keys with PK and foreign keys with FK.List your tables in the following order: RESOURCES,EVENTS,AGENTS,TYPE IMAGES,and LINKING.Use only the following list of attributes (remember that there should be no classes without attributes).
Attributes

Integrated Case Gary Cooper (Yes - That Is His Real Name,and His