Create a relational schema model and relations in SQL with all required constraints. Also attach screenshot of each query executed in Oracle (add your roll no. with each table name to avoid plagiarism).

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

Create a relational schema model and relations in SQL with all required constraints. Also attach screenshot of each query executed in Oracle (add your roll no. with each table name to avoid plagiarism).

Sex
Sex
Firstname
Middlename
Office Ph no
College
Snum
SSN
Lastname
NewAtribute
(Sname )
code
Has major
Class
OH Department
Student
has minor
Dname
Cphoneno
Office_no
Degree
P_phoneno
DOB
Offers
(Current Add)
Permanent Ad
Zip
Cname
decsription
State
city
city
Course
State
level
Zip
Crum
Yeer
semester
Chas section
hours
Takes dass
Section
Sestion.ne
Instructor
Transcribed Image Text:Sex Sex Firstname Middlename Office Ph no College Snum SSN Lastname NewAtribute (Sname ) code Has major Class OH Department Student has minor Dname Cphoneno Office_no Degree P_phoneno DOB Offers (Current Add) Permanent Ad Zip Cname decsription State city city Course State level Zip Crum Yeer semester Chas section hours Takes dass Section Sestion.ne Instructor
Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
SQL Query
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education