Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Given the following tables: students(sid name,age,gpa) courses(cid,deptid, name) . professors(ssn,name,address,phone,deptid) * enrollment(sid cid section,grade, foreign key (sid) references students, foreign key (cid) references courses foreign

image text in transcribed

image text in transcribed

Given the following tables: students(sid name,age,gpa) courses(cid,deptid, name) . professors(ssn,name,address,phone,deptid) * enrollment(sid cid section,grade, foreign key (sid) references students, foreign key (cid) references courses foreign key (cid,section) references teaches) . teaches(cid section,ssn, foreign key (cid) references courses, foreign key (ssn) references professors) Domain cid is in f'198:11', 640:151','198:112'...^ o deptid is in {'cs', 'math','music',...) grade is in ['A''B', C. *section, age, ssn are an integers address, phone, name are strings . gpa is float Provide SQL instructions for each of the following questions Given the following tables: students(sid name,age,gpa) courses(cid,deptid, name) . professors(ssn,name,address,phone,deptid) * enrollment(sid cid section,grade, foreign key (sid) references students, foreign key (cid) references courses foreign key (cid,section) references teaches) . teaches(cid section,ssn, foreign key (cid) references courses, foreign key (ssn) references professors) Domain cid is in f'198:11', 640:151','198:112'...^ o deptid is in {'cs', 'math','music',...) grade is in ['A''B', C. *section, age, ssn are an integers address, phone, name are strings . gpa is float Provide SQL instructions for each of the following questions

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

Managing Your Information How To Design And Create A Textual Database On Your Microcomputer

Authors: Tenopir, Carol, Lundeen, Gerald

1st Edition

1555700233, 9781555700232

More Books

Students also viewed these Databases questions