Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please Post Image of code in SQL Workbench (Or whichever application) Problem 1(12%) 15. Write the SQL commands for creating each of the relations shown

image text in transcribed

image text in transcribed

Please Post Image of code in SQL Workbench (Or whichever application)

Problem 1(12%) 15. Write the SQL commands for creating each of the relations shown below. Specify the primary key(s) and foreign key(s) (if necessary) constrains for each relation in the commands. (9%) Assume the following attribute data types StudentID (integer, primary key) StudentName (25 characters) FacultylD (integer, primary key) FacultyName (25 characters) CourselD (8 characters, primary key) CourseName (15 characters) DateQualied (date) SectionNo (integer, primary key) Semester (7 characters) STUDENT (StudentID, StudentName) QUALIFIED (FacultylD, CourselD, DateQualified) StudentlD StudentName CourselD DateQualified 38214 54907 66324 70542 2143 2143 3467 3467 4756 4756 ISM 3112 ISM 3113 ISM 4212 ISM 4930 ISM 3113 ISM 3112 9/2005 9/2005 9/2012 9/2013 9/2008 9/2008 Altvater Aiken Marra FACULTY (FacultylD, FacultyName) SECTION (SectionNo, Semester, CoureelD) FacultylD FacultyName SectionNo Semester 2143 3467 4756 2712 2713 2714 2715 I-2015 I-2015 Il-2015 Il-2015 ISM 3113 ISM 3113 ISM 4212 ISM 4930 Collins COURSE (CourselD, CourseName) REGISTRATION (StudentID, SectionNo CourselD CourseName StudentiD SectionNo ISM 3113 ISM 3112 ISM 4212 ISM 4930 Syat Analyais Syst Design Database Networking 38214 54907 54907 66324 2714 2714 2715 2713

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

Successful Keyword Searching Initiating Research On Popular Topics Using Electronic Databases

Authors: Randall MacDonald, Susan MacDonald

1st Edition

0313306761, 978-0313306761

More Books

Students also viewed these Databases questions