View the step-by-step solution to:

Student Record Form Student ID: 12345578 Name: James Bond Address: 10 Downing Street, Wellington Email: [email protected] Degree: Bachelor of...

Given the constraint that a student can only register for ONE degree programme.


Draw a 1NF table identifying all the dependencies and the type of dependency. Normalise the 1NF table into 3NF. You must show the progress from 1NF to 2NF, and then to 3NF. Also indicate all the primary keys and foreign keys.


Screen Shot 2018-06-13 at 2.35.13 PM.png

Screen Shot 2018-06-13 at 2.35.13 PM.png

Student Record Form Student ID: 12345578
Name: James Bond Address: 10 Downing Street, Wellington
Email: [email protected]
Degree: Bachelor of Computer Science Course Summary: Code Year Course Name Grade |NF0101 2013 Fundamentals of IS F
FCOM 100 2013 NZ Business Enviro C
ELCM222 2015 E-business Strategyr B+
|NF0101 2014 Fundamentals of IS A
ELCM203 2014 Internet Apps C

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question