Question: 2. (TOTAL: 10 points) Show SQL data definition statements (create table) for the following t relations: STUDENT (SSN,firstName, lastName, age) COURSE (course ID, course_name, SSN,

2. (TOTAL: 10 points) Show SQL data definition statements (create table)

2. (TOTAL: 10 points) Show SQL data definition statements (create table) for the following t relations: STUDENT (SSN,firstName, lastName, age) COURSE (course ID, course_name, SSN, grade). Enforce the following integrity constraints: SSN is a primary key in relation STUDENT - course ID is a primary key in relation COURSE - age - age must be strictly greater than 15 and strictly less than 100 - grade attribute must be A, B, C, D, or F all values for the attribute SSN in the relation COURSE must exist in the relation STUDENT

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!

MAX 506: Fundamentals of Database Management Systems Assignments 6 Dr. Dinakar Jayarajan Total Points: 70 Submit t your work in a single PDF file. Make sure to properly refer to the question numbers...

SQL Query Design Module Preview This guide contains a preview of the materials for all module courses in this series: Using a Relational Database Management System Single Table Query Commands...

Exercise Q1: Regarding the following scenario and the main concepts read the presented requirements and answer the questions: Entities of a mini world relationships can have attributes, operations,...

) Create the SQL statements for displaying the results for each of the following scenarios in the Academic Database. Save these statements in a script called M06_LastNameFirstName_ Queries (where...

IVY TECH COMMUNITY COLLEGE DBMS110 M06 Lab Assignment (19 questions; 40 points total) There are 19 questions listed below. Based on the content in the M06 Readings, answer each question. After...

Project 2 50 points Building upon your project 1, the park will be a Star Wars themed park. You must design additional parts of the database and create the following SQL Script. Step 1: Design and...

Apex Oracle SQL Queries -- CREATING EACH TABLE IN THE ACADEMIC DATABASE CREATE TABLE ACADEMIC_SESSION ( SESSION_ID NUMBER NOT NULL , SESSION_NAME VARCHAR2(50) ) ; CREATE TABLE COURSE ( COURSE_ID...

Narrative/Case Study For this lab, you will be creating SQL statements to build a series of relational tables, using SQL CREATE statements in a script file format for the Student Database. You will...

Provide the $QL for the following data requests. Your SQL should be written as a single script that can be pasted into MySQL and run without edits. Make sure you use the proper notation for your...

Consider transformation T: R3 R3 defined by Where C has RREF Determine dim(Kcr(T)) and dim(lm(T)) of transformation T, and decide whether ii is injective and/or surjective. 2

determine the interest rate earned on 2350 deposit when 2950 is paid back in 1 year

the objective of financial reporting is the foudation of the conceptual framework

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

2. This chapter discussed several trends that will influence the future of training. Based on future social, economic, political, or technological factors, identify one or two additional trends that...

10. What is organization development? Describe the interventions used to create change.

1. Interview a manager. Ask him to evaluate his companys training department in terms of training delivery, service, expertise, and contribution to the business. Ask him to explain the rationale for...