Draw dependency diagram to show the functional dependencies

Assignment Help Basic Computer Science

Reference no: EM132301537

Assignment Task -

Table 1 - Treatment Booking Relation

Cl_id	Cl_name	Pmt_ref	Pmt_amt	Tr_type	Tr_Ses_Price	Tr_Length
C304	Jane Cooper	20167900	$155	Hair Removal	$155	40 minutes
C502	Tom Packer	20167910	$140	Spray tanning	$245	60 minutes
C421	Lisa New	20167841	$89	Facial treatments	$89	30 minutes
C502	Tom Packer	20167230	$90	Deep pore purifying	$195	80 minutes
C405	Ned Nelly	20168720	$92	Microhydrabrasion	$185	50 minutes
C421	Lisa New	20169531	$89	Facial treatments	$89	30 minutes
C309	Kelly Toppak	20166951	$90	Skin Rejuvenation	$360	40 minutes
C304	Jane Cooper	20166500	$100	Hair Removal	$155	40 minutes

Abbreviations list: Cl = Client, Amt = amount, Ses = session, Pmt = Payment, Tr = Treatment

Using the above table -

1. Draw a dependency diagram to show the functional dependencies in the relation.

2. Decompose the relation into a set of 3NF relations.

3. Draw a relational schema for your 3NF relations and show the referential integrity constraints.

NOTE - Manually drawing the dependency diagram, or the set of 3NF relations or the relational schema is NOT acceptable.

Rationale - This assessment task will assess the following learning outcome/s: be able to analyse a database design and apply normalisation theory and techniques.

Reference no: EM132301537

Questions Cloud

Determine the effective capacitance of the capacitors : Determine the effective capacitance of the following combination of capacitors given that the capacitance of each capacitor

Compute the time interval between their passing : Two particles are projected from a point at the same instant with velocities. The time interval between their passing through the other common points

Create spreadsheets that can aid business problem solving : Apply technical knowledge and skills in creating information for the workplace using spreadsheets and relational databases - Communicate with IT professionals

Emergency department based on system archetypes : MGT603: Systems Thinking - Laureate International Universities - Analyse, select and apply systems modelling tools in integrating, optimising and enhancing

Draw dependency diagram to show the functional dependencies : Using the above table - Draw a dependency diagram to show the functional dependencies in the relation. Decompose the relation into a set of 3NF relations

Explain the characteristics of relational databases : Accounting Information Systems - Database Application - Case Study - Explain the characteristics of relational databases and their role in creation

Create a cost-benefit analysis of the proposed new system : ACCT6001 - Accounting Information Systems - Laureate International Universities - Assessment Case Study – Excel-based - create a cost-benefit analysis

Explore the distinction between individuals in crisis : You will explore distinct interview approaches for each of these situations and consider why these approaches would be appropriate

Write a position paper on american history to the civil war : Students must write a position paper focusing on a controversial and/or important topic related to American history to the Civil War.

Reviews

len2301537

5/8/2019 4:05:26 AM

Marking criteria – Each task is worth 4 marks. The dependency diagram accurately identifies and correctly shows all PKs and all functional, partial, and transitive dependencies. The set of 3NF relations accurately identifies and correctly shows all PKs and all the relevant attributes. The relational schema accurately identifies and correctly shows all of the referential integrity constraints. Requirements – Either save your diagrams in a PDF file or embed them in a Word document. Don’t use any other file formats.

Write a Review

Required(*) Message

User Account

All Pages