CONNERTING ER DIAGRAM To SQL STATEMENTS Consider the scenario where you designed an ER diagram and Created relational schema for the Hood College Graduate šchool. hirite SOL Statements to Create the Corresponding relations and Capture as many ef-the Come Canstraiats Constraints as Possibie. Hf you Gnt taptare Enrollment Graduate Program sepester name Has year description admitted courses) deferred domestic international Register Teach Directs matriculation date Students student ID name email address Faculty ASSumptions faculte ID 1. Each graduate program may hare many enrolmenis, but each enroliment must belong to at most one graduate program name 2 We are not interested in enrollment information about a graduate program if the program is no longer offered tille phone number 3. Each student may register for at most one graduate program, and each graduate program may hare many students email address 4 Afaculty member may teach in many graduate programs, and each graduate program must have many faculty members teaching in it 5. Afaculty member may direct at most one graduate program, and each graduate program must be directed by at most one faculty member Relational Schema Graduate_Program (Program name, description, faculty. D) Program- Cour Ses (Program Enroliment C Program name Semester, year, admitted, deferred, domesti- nam , Courses) International) Students (Shudent- ID, Shuent_name, emaul_address, matricalation_dde, Program name) aculby (Facully TD, facutty-name, htle, Phone number, emal_address) Teach (Program name, Facutty ID Type up our SQL CREATE TABLE STATEMENTS FUR THE ABOVE DI AGrRAMg
CONNERTING ER DIAGRAM To SQL STATEMENTS Consider the scenario where you designed an ER diagram and Created relational schema for the Hood College Graduate šchool. hirite SOL Statements to Create the Corresponding relations and Capture as many ef-the Come Canstraiats Constraints as Possibie. Hf you Gnt taptare Enrollment Graduate Program sepester name Has year description admitted courses) deferred domestic international Register Teach Directs matriculation date Students student ID name email address Faculty ASSumptions faculte ID 1. Each graduate program may hare many enrolmenis, but each enroliment must belong to at most one graduate program name 2 We are not interested in enrollment information about a graduate program if the program is no longer offered tille phone number 3. Each student may register for at most one graduate program, and each graduate program may hare many students email address 4 Afaculty member may teach in many graduate programs, and each graduate program must have many faculty members teaching in it 5. Afaculty member may direct at most one graduate program, and each graduate program must be directed by at most one faculty member Relational Schema Graduate_Program (Program name, description, faculty. D) Program- Cour Ses (Program Enroliment C Program name Semester, year, admitted, deferred, domesti- nam , Courses) International) Students (Shudent- ID, Shuent_name, emaul_address, matricalation_dde, Program name) aculby (Facully TD, facutty-name, htle, Phone number, emal_address) Teach (Program name, Facutty ID Type up our SQL CREATE TABLE STATEMENTS FUR THE ABOVE DI AGrRAMg
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
Related questions
Question
![CONVERTING
ER DIAGRAM
TO SQL STATEMENTS
an tR diagram and
Created relational schema for the Hood college Graduate šchool. hirite
SOL Statements to Create the Corresponding relations and Capture
Possible. f you cmot Captare
Consider the
Scenario where you designed
as many ef-the
Some Canstraints
Constraints as
Enrollment
Graduate Program
semester
name
Has
vear
description
admitted
courses}
deferred
domostic
international
Register
Teach
Directs
matriculation date
Students
student ID
name
Faculty
email address
ASsumptions
faculy ID
1. Each graduate program may have many enrolments, but each
enrollment must belong to at most one graduate program.
name
2. We are not interested in enroliment information about a graduate
program if the program is no longer offered.
title
phone number
3. Each student may register for at most one graduate progrem, and
each graduate program may have many students.
email address
4. A faculty member may teach in many graduate programs, and each
graduate program must have many facully members teaching in it.
5. A faculty member may direct at most one graduate program, and
each graduate program must be directed by at most one faculty
member.
Relationaf Schema
Graduate- Program (Program name, description, faculty )
Program - Courses (Program name,
Enroliment CProgram name, Semester, year, admitted, deferred, domestic
Courses)
International)
Students (shudent- ID, Shudent_name, emLaddress, matrculation_dde,
Program_ name)
Faculty TD, facutty-name, htle, Phone_ num ber,
Faculby
Teach (Program name, Faculty ID
Type up our
emel_address)
SQL CREATE TABLE STATEMENTS FUR THE ABONE DI AerRAM](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F53727f86-1ae6-4852-821b-4f2d3213383d%2Fb7a57e00-bc61-4e9d-ba5a-aab760c74950%2Frji63cj_processed.jpeg&w=3840&q=75)
Transcribed Image Text:CONVERTING
ER DIAGRAM
TO SQL STATEMENTS
an tR diagram and
Created relational schema for the Hood college Graduate šchool. hirite
SOL Statements to Create the Corresponding relations and Capture
Possible. f you cmot Captare
Consider the
Scenario where you designed
as many ef-the
Some Canstraints
Constraints as
Enrollment
Graduate Program
semester
name
Has
vear
description
admitted
courses}
deferred
domostic
international
Register
Teach
Directs
matriculation date
Students
student ID
name
Faculty
email address
ASsumptions
faculy ID
1. Each graduate program may have many enrolments, but each
enrollment must belong to at most one graduate program.
name
2. We are not interested in enroliment information about a graduate
program if the program is no longer offered.
title
phone number
3. Each student may register for at most one graduate progrem, and
each graduate program may have many students.
email address
4. A faculty member may teach in many graduate programs, and each
graduate program must have many facully members teaching in it.
5. A faculty member may direct at most one graduate program, and
each graduate program must be directed by at most one faculty
member.
Relationaf Schema
Graduate- Program (Program name, description, faculty )
Program - Courses (Program name,
Enroliment CProgram name, Semester, year, admitted, deferred, domestic
Courses)
International)
Students (shudent- ID, Shudent_name, emLaddress, matrculation_dde,
Program_ name)
Faculty TD, facutty-name, htle, Phone_ num ber,
Faculby
Teach (Program name, Faculty ID
Type up our
emel_address)
SQL CREATE TABLE STATEMENTS FUR THE ABONE DI AerRAM
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![Computer Networking: A Top-Down Approach (7th Edi…](https://www.bartleby.com/isbn_cover_images/9780133594140/9780133594140_smallCoverImage.gif)
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
![Computer Organization and Design MIPS Edition, Fi…](https://www.bartleby.com/isbn_cover_images/9780124077263/9780124077263_smallCoverImage.gif)
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
![Network+ Guide to Networks (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781337569330/9781337569330_smallCoverImage.gif)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
![Computer Networking: A Top-Down Approach (7th Edi…](https://www.bartleby.com/isbn_cover_images/9780133594140/9780133594140_smallCoverImage.gif)
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
![Computer Organization and Design MIPS Edition, Fi…](https://www.bartleby.com/isbn_cover_images/9780124077263/9780124077263_smallCoverImage.gif)
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
![Network+ Guide to Networks (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781337569330/9781337569330_smallCoverImage.gif)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
![Concepts of Database Management](https://www.bartleby.com/isbn_cover_images/9781337093422/9781337093422_smallCoverImage.gif)
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
![Prelude to Programming](https://www.bartleby.com/isbn_cover_images/9780133750423/9780133750423_smallCoverImage.jpg)
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
![Sc Business Data Communications and Networking, T…](https://www.bartleby.com/isbn_cover_images/9781119368830/9781119368830_smallCoverImage.gif)
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY