Question: I5. 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

I5. 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) emester (7 characters STUDENT (StudentiD, StudentName) QUALIFIED (FacultyID, CourselD, DateQualified) StudentiD StudentName 38214 54907 Faculity D ISM 3112 2005 2143 2143 3467 3467 4756 4756 19/200s M 31 13 ISM 4212 66324 /2012 9/2008 2008 ISM 4930 9/2013 ISM 3113 ISM 3112 FACULTY (FacultyD, FaoultyName) SECTION (SectionNo, Semester, CourelD) SectionNio SemesterCounselD 2143 3467 4756 Birkin 2712 2713 2714 2715 I-2015 I-2015 1-2015 l-2015 ISM 3113 ISM 3113 ISM 4212 SM 4930 COURSE (CourselD, CourseName) REGISTRATION (StudentiD, SectionNo) oul CourneNiame StudentioSectionNe ISM 3113 ISM 3112 ISM 4212 ISM 4030 Syst Analysis Syst Design 38214 54907 54907 68324 2714 2714 2715 2713

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

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...

1. Consider a database schema consisting of two relations, whose schemas are: Product (maker, model, type) PC (model, speed, ram, hd, price) The Product relation gives the manufacturer, model number...

There are three parts to this assignment, (PARTS A, B, and C). Be sure to complete all of the parts. BELOW ARE THE FILES THAT YOU WILL SUBMIT FOR THIS ASSIGNMENT: mod2Sql.sql createTruck.sql...

do not copy from Google .do it by your own and write clearly. 1. Considering Employee (Ed. Ename, age Salary, Department) as a relation, Write Sol, commands to (5) a) Delete the employce info of...

1. CAN CASHAPP U 5$ TO DO THIS Write the SQL statements for creating the tables for the Employee Projects Database. Save these statements in a script called M05_LastNameFirstName_CreateTables (where...

1: Draw an ER diagram to represent the data model for the project described below. Include in the data model all entities, relationships, attributes, and all possible constraints. The Guild of...

A . Relational Model Implementation A furniture company has data pertaining to customers, orders, products, and requests, as shown below. CUSTOMER: CUSTOMERNO NAME ADDRESS - - - - - - - - - - - - - -...

the following relational algebra questions based on tables S1 and S2 (below) Question 1 What is the output of S1 S2 ? The row identified by sid 22 The rows identified by sid 31 and 58 The row...

Consider linear transformations mapping vectors in R2 to vectors in R, clearly these are maps from a 2D vectors space to a 1D one. Since the space mapped to is one dimensional, we can call the...

A car engine is operating on the Carnot cycle between a temperature range of 300C and 22C and a maximum and minimum pressures of 70 bar and 2.4 bar. Assume air to be the working fluid. 4.1. Sketch...

QUESTION THREE Investment Criteria: Consider the following cash flows of two mutually exclusive projects for Amazing AL Inc. Assume the discount rate ( required return ) for both projects is 8...

Q4. [3 point] Find the enthalpy of activation (H) and entropy of activation (rS) of the isomerization: transCHCl=CHClcisCHCl=CHClat800.0K. The Arrhenius pre-exponential factor is 5.01012s1. The...

In Visual Studio 2017 with an open OLAP Cube, what is the connection to an advanced OLAP viewer?

What is the main benefit of the multidimensional framework of OLAP Cubes?

Provide an example of how the sort level Unspecified can be excluded from the Gender Dimension in a Pivot Table worksheet genderwaggap01.