Question
Define a nested table to represent the one-to-many relationship between course and section. To complete this lab, do the following steps: 1) Define an Abstract
Define a nested table to represent the one-to-many relationship between course and section. To complete this lab, do the following steps:
Attribute | Data Type |
SecID | NUMBER |
Semester | VARCHAR(20) |
Year | NUMBER |
Attribute | Data Type |
CourseID | VARCHAR(10) |
Title | VARCHAR(20) |
Sections | Section_NT |
Note: Do not forget to name the physical table which will store the data for the nested table Sections.
Course Details | Sections Details |
CourseID=GEIT1411 Title=Computer Science I | SecID=1 Semester=Spring Year=2017 SecID=2 Semester=Spring Year=2017
|
CourseID=GEIT1412 Title=Computer Science II | SecID=1 Semester=Summer Year=2017 SecID=2 Semester=Summer Year=2017
|
CourseID=GEIT2291 Title=Professional Ethics | SecID=1 Semester=Fall Year=2017 SecID=2 Semester=Fall Year=2017 |
CourseID=GEIT3341 Title=Database I | SecID=1 Semester=Fall Year=2017 SecID=2 Semester=Fall Year=2017
|
CourseID=ITAP3371 Title=Database II | SecID=1 Semester=Spring Year=2017 SecID=2 Semester=Spring Year=2017 SecID=3 Semester=Spring Year=2017
|
SecID Semester Year
==================================
1 Spring 2017
2 Spring 2017
Hand in:
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started