Lz help with the following: Translate your ER diagram into a relational schema in the form of SQL DDLs. Choose appropriate data types for each attribute and include primary key and foreign key constraints, Check and Not Null constraints.

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
100%

PLz help with the following:

  1. Translate your ER diagram into a relational schema in the form of SQL DDLs. Choose appropriate data types for each attribute and include primary key and foreign key constraints, Check and Not Null constraints.

SUBJECT 1
SUB ID
COURSE
SUBJECT 2
SEMESTER
SUBJECT 3
NAME
EB ID
FB DATA
SREGNO
SUBJECT 9
SUBJECT 4
INTERACTION
SUBJECT
DETAILS
SUBJECT 8
REMARKS
SUBJECT 5
SUBJECT 7
STAFF
NAME
FEEDBACK
STID
DETAILS
SUBJECT 10
SUBJECT 6
KNOWLEDGE
ALLOTID
SFID
SFID
ALLOT SUBJECT
PUNCTUAL
SEND
FEEDBACK
TIMETABLE
STAFF
SUBJECTS
SEMESTER
COURSE
SUB ID
SUBJECTS
SFADDRESS
SUBJECT
SFID
COURSE
SFQUALIFIC
NAME
NAME
STID
ATION
ADD SUBJECT
SFNAME
SFEMAIL
SFID
ADD STAFF
STAFF
DETAILS
ASSESMNT
ASSESMENT
ID
SFMOBILEEQ
DETAILS
USERNAME
PASSWORD
START
DATE
SET UP AN
ANASSESMET
END DATE
COURSE ID
ANSWER AN
ANASSESMET
COURSE
NAME
COURSE
DETAILS
SHORT
NAME
SEND MESSAGE
SEND QUERY/ VIEW
MESSAGE
ADD COURSE
VIEW QUERY
ADDRESS
ATTENDANCE
STID
PHONE
PASSWORD
STUDENT
QRDATE
DETAILS
ANSWER
STUDENT
EMAIL
QUERY
USERNAME
QRID
DOCUMENT
COURSE
ID
NAME
SEMESTER
MARKS
STID
SREGNO
REGNO
SFID
STAFF
QUESTION
STATUS
SNAME
NAME
Transcribed Image Text:SUBJECT 1 SUB ID COURSE SUBJECT 2 SEMESTER SUBJECT 3 NAME EB ID FB DATA SREGNO SUBJECT 9 SUBJECT 4 INTERACTION SUBJECT DETAILS SUBJECT 8 REMARKS SUBJECT 5 SUBJECT 7 STAFF NAME FEEDBACK STID DETAILS SUBJECT 10 SUBJECT 6 KNOWLEDGE ALLOTID SFID SFID ALLOT SUBJECT PUNCTUAL SEND FEEDBACK TIMETABLE STAFF SUBJECTS SEMESTER COURSE SUB ID SUBJECTS SFADDRESS SUBJECT SFID COURSE SFQUALIFIC NAME NAME STID ATION ADD SUBJECT SFNAME SFEMAIL SFID ADD STAFF STAFF DETAILS ASSESMNT ASSESMENT ID SFMOBILEEQ DETAILS USERNAME PASSWORD START DATE SET UP AN ANASSESMET END DATE COURSE ID ANSWER AN ANASSESMET COURSE NAME COURSE DETAILS SHORT NAME SEND MESSAGE SEND QUERY/ VIEW MESSAGE ADD COURSE VIEW QUERY ADDRESS ATTENDANCE STID PHONE PASSWORD STUDENT QRDATE DETAILS ANSWER STUDENT EMAIL QUERY USERNAME QRID DOCUMENT COURSE ID NAME SEMESTER MARKS STID SREGNO REGNO SFID STAFF QUESTION STATUS SNAME NAME
Expert Solution
steps

Step by step

Solved in 6 steps with 1 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