Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
loader

Phone no. Missing!

Enter phone no. to receive critical updates and urgent messages !

Add File

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Guaranteed Higher Grade!

ICT701 Relational Database Systems

tag 1 Download 2 Pages / 409 Words tag 13-07-2021

Question:

Students are to create a database design specification (entity relationship diagram (ERD) and relational data model (RDM)) from the given business description below. Students are to present this in a report (as specified in the submission format) which also includes a short discussion of the approach for the solution. This assignment is

to be carried out and reported individually.

The following defines the minimum information that should be reported:

  1. A brief discussion of your solution, i.e. how you approached the modelling problem and any issues you may have encountered (maximum of ½ page).
  2. The Entity Relationship Diagram (ERD) (produced using a drawing tool such as those found in MS Word or PowerPoint, or a chosen CASE tool) for the system. Your ERD must use the ER notation that was taught in ICT701. Any assumptions made in creating the ERD must be explicitly stated in your report.
  3. The Relational Data Model (RDM) which corresponds to the ERD. That is, the set of tables in 3rd normal formthat could be used to represent the whole of this data model. Your RDM should identify primary, alternate and foreign keys.

Jo Bloggs Auto Traders sells motor vehicles. They sell new and used vehicles. For all vehicles, they store the unique vehicle id and the chassis number. For new vehicles, they also store information about the manufacturer name, colour, price, discount (there are 44 types of discount, each of a fixed percentage), engine capacity and details about extras, which would include car radios, air conditioning, etc.

For used cars, they only store vehicle id, price and description. Each new vehicle has only one manufacturer (but a manufacturer may supply many different vehicles), and they store details about the manufacturer’s name, address, telephone and industry rank. A manufacturer may have many addresses, each of a particular type (e.g. postal) and one telephone number only per address. For new cars, each car may have many extras, for example ‘RA’ would signify car radio. Jo Bloggs employs many salespeople who sell to clients. For salesperson and client, they store name and address. For each sale, they store the client details, the vehicle details, the price and the commission to the salesperson. An interesting point: only one client may buy a particular vehicle but several salespeople may share the sale.

Resolve the following relation to 3rd Normal Form. It is a requirement to show both the 1NF and 2NF that you found as part of the process in moving to 3NF.

COMPACT_DISK(title number, album name, distributor id, distributor name,((track number, track name, track duration, ((artist id, artist name, date of birth, age, instrument_type, instrument description )) )) )

NOTE: The brackets in the above unnormalised relation data indicate non-atomic attributes (or repeating groups)

Complete the following SQL tasks using MySQL. The marks available for each SQL task are indicated.

  • Write the SQL code that will create the table structure for a table named EMPLOYEE. The basic EMPLOYEE table structure is summarized in the table below.
Download Sample Now

Earn back the money you have spent on the downloaded sample by uploading a unique assignment/study material/research material you have. After we assess the authenticity of the uploaded content, you will get 100% money back in your wallet within 7 days.

Upload
Unique Document

Document
Under Evaluation

Get Money
into Your Wallet

Total 2 pages

Cite This Work

To export a reference to this article please select a referencing stye below:

My Assignment Help. (2021). ICT701 Relational Database Systems. Retrieved from https://myassignmenthelp.com/free-samples/ict701-relational-database-systems/relational-schema.html.

"ICT701 Relational Database Systems." My Assignment Help, 2021, https://myassignmenthelp.com/free-samples/ict701-relational-database-systems/relational-schema.html.

My Assignment Help (2021) ICT701 Relational Database Systems [Online]. Available from: https://myassignmenthelp.com/free-samples/ict701-relational-database-systems/relational-schema.html
[Accessed 28 January 2023].

My Assignment Help. 'ICT701 Relational Database Systems' (My Assignment Help, 2021) <https://myassignmenthelp.com/free-samples/ict701-relational-database-systems/relational-schema.html> accessed 28 January 2023.

My Assignment Help. ICT701 Relational Database Systems [Internet]. My Assignment Help. 2021 [cited 28 January 2023]. Available from: https://myassignmenthelp.com/free-samples/ict701-relational-database-systems/relational-schema.html.


Stuck on Any Question

Our best expert will help you with the answer of your question with best explanation.

question
We will use e-mail only for:

arrow Communication regarding your orders

arrow To send you invoices, and other billing info

arrow To provide you with information of offers and other benefits

Phone no. Missing!

Enter phone no. to receive critical updates and urgent messages !

loader
250 words
Error goes here

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

We Can Help!

Get top notch assistance from our best tutors !
Excel in your academics & career in one easy click!

icon

Other Samples

Content Removal Request

If you are the original writer of this content and no longer wish to have your work published on Myassignmenthelp.com then please raise the content removal request.

icon

5% Cashback

On APP - grab it while it lasts!

Download app now (or) Scan the QR code

*Offer eligible for first 3 orders ordered through app!

screener
ribbon
callback request mobile
Have any Query?
close
Subtraction Payment required!

Only one step away from your solution of order no.