Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

2.1 Design the following two tables (in addition to that in Figure 2.1) that might be used in the Student Registration System. Note that the

image text in transcribed
image text in transcribed
2.1 Design the following two tables (in addition to that in Figure 2.1) that might be used in the Student Registration System. Note that the same student Id might appear in many rows of each of these tables. a. A table implementing the relation COURSESREGISTEREDFOR, relating a student's Id and the identifying numbers of the courses for which she is registered b. A table implementing the relation COURSESTAKEN, relating a student's Id, the identifying numbers of the courses he has taken, and the grade received in each course Name Status Id 111111111 666666666 111223344 John Doe Joseph Public Mary Smith Bart Simpson Homer Simpson Joe Blow Address 123 Main St. 666 Hollow Rd. 1 Lake St. Fox 5 TV Fox 5 TV 6 Yard Ct. Freshman Sophomore Freshman Senior Senior Junior 987654321 023456789 123454321 FIGURE 2.1 The table STUDENT. Each row describes a single student

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Secrets Of Analytical Leaders Insights From Information Insiders

Authors: Wayne Eckerson

1st Edition

1935504347, 9781935504344

More Books

Students also viewed these Databases questions

Question

=+ Have they changed the way employers view IP?

Answered: 1 week ago