show every step and the final solution should be like the example provided dont answer in any other way
example
the final solution should be like this
Read and analyse the following specification of a sample database domain. A network of vehicle repair services would like to create a database with information about the vehicles, owners of vehicles, repairs performed on vehicles, and staff employed at the repair service nodes. A network consists of the service nodes distributed all over a state. Each service node is located at a different address. An address consists of a city name, street, name and building number. Each node has a name, that is unique in a city it is located at. It is possible that two nodes located in different cities have the same names. Each node has a unique phone number and unique email address The nodes employ mechanics, apprentices, office staff, and a manager as the staff members. An employee is described by a unique employee# first name, last name, date of birth, and hire date. A collection of four attributes that includes first name, last name, date of birth, and hire date is unique for each employee. Additionally, mechanics are described by a list of qualifications possessed, apprentices are described by the current year of their apprenticeship, and their specialisation (mechanic, panel-better or auto-electrician) office staff members are described by a list of IT Skills possessed and management and staff members are described by a position occupied. An employee can work at only one service node. The owners bring their vehicles to services nodes for repairs. Information about an owner includes the first name, last name, email address and unique phone number. A vehicle is described by a unique registration number, make, model, and manufacturing year. We consider two types of vehicles cars and trucks. A truck has the same description as a car, and additionally, it is described by capacity. Each time a vehicle is brought for repairs a date and time is recorded. A vehicle can be repaired at any of the service nodes included in the network, and any node can repair any vehicle. When a repair process is completed date and time when an owner collects a vehicle is recorded. Note that a repair process takes some time, and its completion date is not known when the process is started. A repair process consists of one or more steps. Each step has a number, which is unique within a process, a short description, and a list of parts used at a step. The mechanics that were involved in each step of the repair process and how much time each one of the team members spent on each step is recorded. A mechanic can be involved in many repair steps, and each step may require the involvement of many mechanics Step 1 - Identify the object classes Step 2 - Attributes and IDs Step 3: Create attributes and link attributes Step 4: Create identifiers and qualifications Step 5: Create generalizations Final Solution (1) Draw a conceptual schema for the specification of the database domain listed above. Use the UML simplified class diagrams explained during this subject. Note: you are not allowed to use any artificial identifiers (create new IDs) and or add any attributes that are not explicitly mentioned in the specification. Use UMLet to draw the schema and paste images of your drawings into your Microsoft Word document using the template provided. Add your name, student number and the date to your diagram. There is NO NEED to provide a detailed analysis of how the conceptual schema has been created. (7 marks) (2) Add two (2) new object classes with at least three (3) attributes each and appropriate associations. The choice of object classes, attributes and associations are up to you; however, these should relate to the existing scenario. Use UMLet to draw the changes to the schema and paste the second diagram into your Microsoft Word document under a heading called Variation. Write a text description that explains the additional objects, attributes and associations below this diagram. (3 marks) ORDER order# ID order-date Contains 0..1 LINE ITEM line# 1..* Submits Lists SHIPPED-PART CUSTOMER customer# 101 first-name last-name phone ID2 PART part# ID name price manufacturer shipment-date 1..* Is-shipped-by FREQUENT-CUSTOMER discount 1..* SUPPLIER supplier-name 101 country ID2 city ID2 street ID2 building# ID2 phone ID3 Consists-of 0..1 Read and analyse the following specification of a sample database domain. A network of vehicle repair services would like to create a database with information about the vehicles, owners of vehicles, repairs performed on vehicles, and staff employed at the repair service nodes. A network consists of the service nodes distributed all over a state. Each service node is located at a different address. An address consists of a city name, street, name and building number. Each node has a name, that is unique in a city it is located at. It is possible that two nodes located in different cities have the same names. Each node has a unique phone number and unique email address The nodes employ mechanics, apprentices, office staff, and a manager as the staff members. An employee is described by a unique employee# first name, last name, date of birth, and hire date. A collection of four attributes that includes first name, last name, date of birth, and hire date is unique for each employee. Additionally, mechanics are described by a list of qualifications possessed, apprentices are described by the current year of their apprenticeship, and their specialisation (mechanic, panel-better or auto-electrician) office staff members are described by a list of IT Skills possessed and management and staff members are described by a position occupied. An employee can work at only one service node. The owners bring their vehicles to services nodes for repairs. Information about an owner includes the first name, last name, email address and unique phone number. A vehicle is described by a unique registration number, make, model, and manufacturing year. We consider two types of vehicles cars and trucks. A truck has the same description as a car, and additionally, it is described by capacity. Each time a vehicle is brought for repairs a date and time is recorded. A vehicle can be repaired at any of the service nodes included in the network, and any node can repair any vehicle. When a repair process is completed date and time when an owner collects a vehicle is recorded. Note that a repair process takes some time, and its completion date is not known when the process is started. A repair process consists of one or more steps. Each step has a number, which is unique within a process, a short description, and a list of parts used at a step. The mechanics that were involved in each step of the repair process and how much time each one of the team members spent on each step is recorded. A mechanic can be involved in many repair steps, and each step may require the involvement of many mechanics Step 1 - Identify the object classes Step 2 - Attributes and IDs Step 3: Create attributes and link attributes Step 4: Create identifiers and qualifications Step 5: Create generalizations Final Solution (1) Draw a conceptual schema for the specification of the database domain listed above. Use the UML simplified class diagrams explained during this subject. Note: you are not allowed to use any artificial identifiers (create new IDs) and or add any attributes that are not explicitly mentioned in the specification. Use UMLet to draw the schema and paste images of your drawings into your Microsoft Word document using the template provided. Add your name, student number and the date to your diagram. There is NO NEED to provide a detailed analysis of how the conceptual schema has been created. (7 marks) (2) Add two (2) new object classes with at least three (3) attributes each and appropriate associations. The choice of object classes, attributes and associations are up to you; however, these should relate to the existing scenario. Use UMLet to draw the changes to the schema and paste the second diagram into your Microsoft Word document under a heading called Variation. Write a text description that explains the additional objects, attributes and associations below this diagram. (3 marks) ORDER order# ID order-date Contains 0..1 LINE ITEM line# 1..* Submits Lists SHIPPED-PART CUSTOMER customer# 101 first-name last-name phone ID2 PART part# ID name price manufacturer shipment-date 1..* Is-shipped-by FREQUENT-CUSTOMER discount 1..* SUPPLIER supplier-name 101 country ID2 city ID2 street ID2 building# ID2 phone ID3 Consists-of 0..1
