Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
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
40 minutes
C502
Tom Packer
20167910
$140
Spray tanning
$245
60 minutes
C421
Lisa New
20167841
$89
Facial treatments
30 minutes
20167230
$90
Deep pore purifying
$195
80 minutes
C405
Ned Nelly
20168720
$92
Microhydrabrasion
$185
50 minutes
20169531
C309
Kelly Toppak
20166951
Skin Rejuvenation
$360
20166500
$100
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.
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.
Windows NotePad is a simple text editor. What is the difference between a text editor and a word processor?" What is an HTML Text Editor? What is it used for and how does it compare to a regular text editor
What role does a factor play in providing short-term financing to a firm? Why would firms that rely heavily on credit sales find factoring attractive?
Product Supply Turns to Shadow IT You are a section manager in the product supply department of a midsized manufacturing firm.
We have learned this week about deductive reasoning, including what it takes for an argument to be valid. This discussion allows us to get more practice with the concept through making arguments valid. You will see a list of arguments here.
Suppose the market demand function for ice cream is Qd = 10 - 2P and the market supply function for ice cream is Qs = 4P - 2
The program should pass these values to a function that returns the future value of the account after the specified number of months. The program should display the accounts future value.
What is the best tip for learning about computer processing time, execution time, computer systems
Where are these three characteristics of customer engagement? Explain why these three characteristics attribute to a customer-focused culture.
The mean finishing time was 78.21 seconds, with a standard deviation of 1.03 seconds. If the Normal model is appropriate, what percent of the times should be within 0.5 second of 78.21?
Also, Explain demand and supply curves, explain how to know when to move along the curve and when to shift the curve given various situations.
In the process, the bank gave enormous trading authority to one individual. What are the ERM strengths and weaknesses of this strategy?
Discuss the role of government in developing countries in Healthcare reform. What are the difficulties and the good policies to solve this risks and challenges?
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd