Hi this is final assesment which is very important to me I want you to do this for me and submit to...

Question

Hi this is final assesment which is very important to me I want you to do this for me and submit to me on time you have to do 4 questions from 7 so choose easy one and then do most important thing there is mentioned at the end of every question that which format is needed so I want all and exact formats secondly you have to mention my name ID and date on every document so kindly don't forget to mention themSTUDENT NAME: AHMER NASIRSTUDENT ID: 6880101

DPIT115: Data Management and SecuritySummer Session 2020 Student Number: Student Name: Question 1 (10 marks) 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 Page 2 of 2 DPIT115: Data Management and SecuritySummer Session 2020 Student Number: Student Name: Question 2 (10 marks) Page 2 of 2 DPIT115: Data Management and SecuritySummer Session 2020 Student Number: Student Name: Question 3 (5)Explain how the use of consistency constraints support the management of data security. Use original examples to illustrate your answer. (2 marks) Page 2 of 2 /* DPIT115 : Data Management and Security SESSION : Spring Session 2020 TASK : Final Assignment - Question 3 FILE : Question 3 STUDENT NAMES : STUDENT NUMBER : STUDENT EMAIL: DATE :

*/ /* (0)Assume that the user ‘root’ with a password 'DPIT115' created a database called transport and the user ‘root’ executed CREATE TABLE statements given on page 2 of the examination paper to create the relational tables in the database transport.*/ /* (1)Modify the consistency constraint of the sample database such that after the modification, it is possible to record in the database information about the trucks that have a capacity up to and including 200. (2 marks)*/ /* (2)Modify the structure and consistency constraints of the sample database such that it is possible to store information in the database about the total number of legs a trip contains. Assume that a trip cannot contain of more than 10 legs. (2 marks)*/ /* (3)Modify the structure and consistency constraints of the sample database such it is possible to store information in the database about the mechanics employed by a transportation company. Assume that a description of mechanic consists of an employee number, first name, last name, date of birth and qualification level. A qualification level is a positive integer number 1 or 2 or 3 or 4 or 5. Remember that a mechanic is an employee. (2 marks)*/ /* (4)Modify the consistency constraints of the sample database, so it is possible to store information about the trip without providing information about a driver licence number. Such modification is required when a driver leaves a transportation company, and we would like to keep information about all trips performed by the driver.(2 marks)*/

dpit115-final-assignment-summer-2020-olf33z4b.pdf question1-xzkkilj5.docx question2-ktw2tsj3.docx question3-j1jzhhev.docx question3-hupt5itb.sql

Deepti · Accepted Answer

Solution-74993/question1.docx
DPIT115: Data Management and Security	Summer Session 2020
Student Number: Ahmer Nasir					Student Name:6880101 
Question 1 (10 marks)
Step 1 – Identify the object classes
Vehicles
Owners
Repairs
Staff
ServiceNode
Step 2 – Attributes and IDs
NodeName, NodePhone, NodeEmail, NodeCity, NodeStreet, NodeBuildingNumber
Employee#, first name, last name, date of birth, hire date, Qualifications, YearOfApprenticeship, Specialization, ITSkills, Position
OwnerFirstName, OwnerLastName, OwnerEmail, Ownerphone
RegNo, Make, Model, ManufactureYear, Capacity
RepairBroughtDate, RepairBroughtTime, RepairCollectDate, RepairCollectTime
StepNo, Description, Parts
Final Solution
VARIATION
Payments are made by the owners once the repair is completed. Receipt details are recorded. The new classes added to the system are Payment and Receipt. Class payment has three attributes as Payment ID which uniquely identifies each Payment made, Bill amount and Date on which it is paid. The class Receipt is identified by Receipt ID, description is included about the receipt and the Date on which the receipt is issued. 
Page 2 of 2
Solution-74993/question1.pdf
DPIT115: Data Management and Security Summer Session 2020 
Student Number: Ahmer Nasir     Student Name:6880101  
Page 1 of 2 
 
Question 1 (10 marks) 
Step 1 – Identify the object classes 
Vehicles 
Owners 
Repairs 
Staff 
ServiceNode 
Step 2 – Attributes and IDs 
NodeName, NodePhone, NodeEmail, NodeCity, NodeStreet, NodeBuildingNumber 
Employee#, first name, last name, date of birth, hire date, Qualifications, 
YearOfApprenticeship, Specialization, ITSkills, Position 
OwnerFirstName, OwnerLastName, OwnerEmail, Ownerphone 
RegNo, Make, Model, ManufactureYear, Capacity 
RepairBroughtDate, RepairBroughtTime, RepairCollectDate, RepairCollectTime 
StepNo, Description, Parts
DPIT115: Data Management and Security Summer Session 2020 
Student Number: Ahmer Nasir     Student Name:6880101  
Page 2 of 2 
 
Final Solution
VARIATION
Payments are made by the owners once the repair is completed. Receipt details are 
recorded. The new classes added to the system are Payment and Receipt. Class payment 
has three attributes as Payment ID which uniquely identifies each Payment made, Bill 
amount and Date on which it is paid. The class Receipt is identified by Receipt ID, 
description is included about the receipt and the Date on which the receipt is issued.  
Solution-74993/question2.docx
DPIT115: Data Management and Security	Summer Session 2020
Student Number: 6880101				Student Name: Ahmer Nasir
Question 2 (10 marks)
The table ‘Owner-seller’ has details of those customers who own a property and want to sell it. So they have Phone# as foreign key referring to primary key of ‘Customer’.
Table ‘Employees’ refers to ‘Branch’ through phone primary key. Each employee is associated with a branch through the branch’s phone number.
‘Property-on-market’ table refers to ‘agent’ through Business-phone#. ‘Training-course’ refers to ‘Junior-agent’ through Business-phone#.

DPIT115: Data Management and SecuritySummer Session 2020 Student Number: Student Name: Question 1 (10 marks) Step 1 – Identify the object classes Step 2 – Attributes and IDs Step 3: Create attributes...

Answer To: DPIT115: Data Management and SecuritySummer Session 2020 Student Number: Student Name: Question 1...

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment