Database Homework Help At an orthondontists office an engine

Database Homework Help

At an orthondontist\'s office, an engineer from the NeverStudied School of Database Design created a database that is not working very well. Each time a patient comes in to one of their offices (they have several to choose from), the staff must be able to record the treatment given and the costs for billing. Given the engineer\'s schema and functional dependencies What is the key of the original ORTHODONTIST VISIT table? tell if the relation is 1NF. (If it is, tell how you know. If not put it in 1NF form.) then, tell if the relation is 2NF. (If it is, tell how you know. If not put it in 2NF form.) then, tell if the relation is 3NF. (If it is, tell how you know. If not put it in 3NF form.) Office # rightarrow {Doc#, O Address} Patient # rightarrow {PName} Doc# rightarrow {Doc Name, DocDeg} Treatment # rightarrow {TCost, TreatmentGiven} {Office#, Treatment#, Patient#} rightarrow {Appt Date, ApptTime} TCost is a composite attribute that accounts for LaborCosts and SuppliesCosts. Visit is a multivalued, composite attribute that consists of the atoms ApptDate, ApptTime, TreatmentGiven, Treatment# and TCost. Full credit will not be given unless you show all Functional dependency diagrams for all normal forms.

Solution

10/eleven/2007 replace: there\'s some other student on the UM who has a Jackson answers page up. He has answers totally distinctive from the ones i\'ve gathered (from the 2004-2005 year), and his website online is: http://www-non-public.umich.edu/~jbourj/em.htm.

12/19/2007 update: thanks to a modern-day Jackson scholar on the university of Michigan, we have the autumn 2007 Physics 505 answers!

04/20/2008 replace: the fall 2007 solutions now encompass problem assignments and the very last, and we\'ve iciness 2008 solutions as properly!