3. Decompose the following relation into 1NF. Show each step carefully – not just the final relation. PARENT CHILD ID_NUMBER NAME NAME AGE 01 JOHN SARAH 10 TIM 6 02 JANET JEREMY 10 JANE 12 4. List the FD's that hold for the relation WHICH_COLLEGE. MAJOR_ID COLLEGE DEPARTMENT M1 C1 D1 M1 C2 D1 M2 C2 D1 M3 C2 D2 M4 C2 D2 WHICH_COLLEGE MAJOR_ID refers to a major, offered by a COLLEGE, in a particular DEPARTMENT
Added by Rosa S.
Close
Step 1
The repeating groups are the CHILD, ID, NUMBER, NAME, and AGE attributes. Show more…
Show all steps
Your feedback will help us improve your experience
Md.Daniyal Arshad and 53 other Intro Stats / AP Statistics educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
Write the following queries in relational algebra, using the university schema. a. Find the ID and name of each instructor in the Physics department. b. Find the ID and name of each instructor in a department located in the building "Watson". c. Find the ID and name of each student who has taken at least one course in the "Comp. Sci." department. d. Find the ID and name of each student who has taken at least one course section in the year 2018. e. Find the ID and name of each student who has not taken any course section in the year 2018.
Akash M.
Recommended Textbooks
Elementary Statistics a Step by Step Approach
The Practice of Statistics for AP
Introductory Statistics
Transcript
Watch the video solution with this free unlock.
EMAIL
PASSWORD
