Write a database description for each of the relations shown, using SQL DDL (shorten, abbreviate, or change

Question:

Write a database description for each of the relations shown, using SQL DDL (shorten, abbreviate, or change any data names, as needed for your SQL version). Assume the following attribute data types:
StudentID (integer, primary key) StudentName (25 characters) FacultyID (integer, primary key) FacultyName (25 characters) CourseID (8 characters, primary key)
CourseName (15 characters) DateQualified (date) SectionNo (integer, primary key) Semester (7 characters) 

STUDENT (StudentlD, StudentName) QUALIFIED (FacultylD, CourselD, DateQualified) StudentName StudentID CourselD FacultyID


Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Essentials of Database Management

ISBN: 978-0133405682

1st edition

Authors: Jeffrey A. Hoffer, Heikki Topi, Ramesh Venkataraman

Question Posted: