Hi,

 I think you had done my Database assignment-1. I also told the second Assignment will be related to Assignment -1. I am attaching my Assignment -2 document, please review it and let me know when it can be done. I can offer you same price. If you need assignment -1 ERD I wil send you.

 

COIT20247 Database Design and Development (T2 2016)Assessment item 2—Assignment 2Due date11:45pm on Friday of Week 10 (September 21, 2016)Weighting35%LengthNot applicableObjectivesThis assessment item relates to the course learning outcomes numbers 1, 2 and 3 as statedin the course profile.IntroductionThe sample solution of assignment 1 will be released on the course website approximatelytwo (2) weeks after the assignment 1 due date.Youmust use that sample solution ofassignment 1 onlyfor the following tasks:Assessment task1Normalizationa)Map the ERD, from the sample solution, into aset of relationsin at least ThirdNormal Form (3NF). You must ensure that your relations meet 3NF. There is noneed to show your working.b)Select any two (2) of your relations from the previous step, 1a), and perform the followingfor each of those two relations:List all thefunctional dependenciesexist in the relation.Demonstrate that the relation meetsThird Normal Form (3NF).For your help, an example for a Student relation’s 3NF justification has been provided below:STUDENT (StudentID, Name, Address, DateOfBirth)i.The primary key is StudentID.There will be one student name per Student ID, since onlyone name is recorded for each student. There will be one address per Student ID; eventhough a student may have multiple address (e.g. a home address and a work address),the case study states that there is a need to record the home address only. There will beonly one date of birth per Student ID.Thus, there are no repeating groups. Hence, thisrelation is in 1NF.ii.The primary key is StudentID.This is the only candidate key since Name is notguaranteed to be unique (two different students may have the same name).Address isalso not guaranteed to be unique. This means that Student ID functionally determinesevery other attribute in the table.There is a single simple candidate key (StudentId) andtherefore no partial dependencies are possible.Hence, the relation is in 2NF.iii.Name cannot be used to functionally determine any other attribute in the table since twodifferent students may have the same name; likewise for address and date of birth.Therefore there are no transitive dependencies in the table.Therefore it meets therequirements of first, second and third normal form.

• 1495172236-a2Spec.docx

ComputerScienceExpert

(11)

Status NEW Posted 19 May 2017 05:05 AM My Price 9.00

-----------

Attachments

file 1495172239-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer