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

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

Problem 1(12%) 15. Write the SQL commands for creating each of the

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

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!

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

MKT500 Week 7 Discussion Board I have attached the question, lecture notes, and an example of a student's response to the questions. Running head: KEYSAN NATURALS COMPANY: AIDA PRINCIPLE Keysan...

Question 1: Triggers and Stored Procedures: Download the file named assignment4_database.sql from D2L. Run the file from MySQL workbench, putty or Terminal. If using Metrostate login via Putty or...

This is the second time that I submit this project, the solution was wrong, if you would be so kind to solve the project for me correctly and completely and in SQL language with a screenshot of the...

Lesson 12 Quiz (Show/Explain all Work) IST 230 Relations on Sets, Databases 1. Let A = {0, 1, 2, 3, 4, 5, 6, 7, 8} and B = {1, 2, 3, 4, 5, 6, 7, 8}. Now let R be a binary relation R from A to B such...

*Lab 6 is there in case you don't know what "Lab 7" instructions are referring to when they say" Lab 6." Lab 7 is the one that needs to be done. Lab 7: Inserting and Updating Data OVERVIEW This lab...

CHA P TER 9 Understanding Software: A Primer for Managers 1. INTRODUCTION L E A R N I N G O B J E C T I V E S 1. Recognize the importance of software and its implications for the rm and strategic...

This SQL project in three Phases and the instruction as below: Instructions Follow the steps and let me know if you have any questions. The intent of the project is to create a project you can use in...

What is the difference between MouseListener and MouseAdapter? [3 marks] (b) Via suitable HTML, the compiled version of the following Java code is presented to the appletviewer application: import...

io (a) Give the general formula for estimating transition probabilities from training data. Provide the full transition matrix A for this HMM based on the training data shown. [6 marks] (b) Give the...

Proctor & Gamble, a major manufacturer of household products including laundry detergent, estimates that the average household does 25 loads of laundry per month. Random sample of 18 households...

The fuel consumption of an airplane is measured in gal/mi (gallon per mile) or in L/km (liter per kilometers). Write a MATLAB user-defined function that converts fuel efficiency consumption from...

To raise capital fundh, Twist Inc, issoed $ 2 millice worth of debentires with warrasts atached. The warranss had an esercise price of $ 1 5 , and each warrant entitled the holker to reo ihares of...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

2. Discuss the impact on an individual employee and work unit if organizational justice is not honored by managers. Recall any past work experience you may have in which a supervisor played...

3. Give some examples of how technology is creating employeremployee rights and policy issues. Then suggest some possible actions that may be needed.

4. Discharge: If the employee fails to follow the action plan that was developed and problems continue, then the supervisor can discharge the employee. #!# 1. Identify how overreliance on the...