Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

possible to record in the database information about the trucks that have a capacity up to and including 225. (2 marks) (2) Modity the structure

image text in transcribed

possible to record in the database information about the trucks that have a capacity up to and including 225. (2 marks) (2) Modity the structure and consistency constraints of the sample database such that after the modification, it is possible to store information in the database about the total number of legs a trip contains. Assume that a trip cannot contain more than 10 legs. (2 marks) (3) Modity the structure of the sample database so it is possible to store information in a new table in the database about mechanics employed by a transportation company. Assume that a description of a 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 or 6 . Remember that a mechanic is an employee. (2 marks) (4) Modity 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 pertormed by the driver. (2 marks) (5) Explain how the use of consistency constraints supports the management of data security. Use original examples that you make up yourself to illustrate your answer. (2 marks) Add your code into the question2.sql template provided and output your report file on your virtual machine to a file named question2.rpt

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

2. Explain in English what the following FA accepts. A 01 03 0,1

Answered: 1 week ago