Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

What's the Foreign Key(s) of the students table? 2) What's the Foreign Key(s) of the Classes table? 3) What's the Foreign Key(s) of the Courses

What's the Foreign Key(s) of the students table?

2) What's the Foreign Key(s) of the Classes table?

3) What's the Foreign Key(s) of the Courses table?

 

4) What's the Foreign Key(s) of the Enrollments table?

 

11111.png 

Students Snum Sname Courses Major 101 Andy IS 102 Betty IS 103 Cindy FIN 104 David FIN 12232 GPA Dept Code Title CrHr 2.5 2.8 3.1 2.4 5885 IS 300 Intro to MIS IS 301 Statistics MKT 301 Intro to Marketing 3 MKT 304 Int'l Marketing mmmm 3 3 105 Ellen MKT 3.8 106 Frank IS 3.8 Classes Enrollments CallNum Dept Code Section# Semester SNUM CallNum GRADE 10111 IS 300 1 2004Fa 101 10111 10112 IS 300 2 2004Fa 102 10111 10113 IS 301 1 2004Fa 103 10111 10114 IS 300 1 2005Sp 101 10114 10115 IS 300 2 2005Sp 102 10116 10116 MKT 301 1 2005Sp 103 10116 10117 MKT 301 2 2005Sp 103 10114 102 10114 ABABAACA

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

A Pathway To Introductory Statistics

Authors: Jay Lehmann

1st Edition

0134107179, 978-0134107172

More Books

Students also viewed these Databases questions

Question

What were the processes that caused the outcomes?

Answered: 1 week ago