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

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

STUDENT (StudentlD, StudentName) QUALIFIED (FacultylD, CourselD, DateQualified) StudentName StudentID CourselD FacultyID DateQualified ISM 3112 ISM 3113 38214 Letersky Altvater 2143 9/1988 2143 54907 9/1988 9/1995 66324 70542 Aiken Marra 3467 ISM 4212 3467 4756 ISM 4930 ISM 3113 9/1996 9/1991 4756 ISM 3112 9/1991 FACULTY (FacultylD, FacultyName) SECTION (SectionNo, Semester, CourselD) FacultyID SectionNo FacultyName Semester CourselD ISM 3113 2143 3467 Birkin 1-2008 1-2008 2712 Berndt 2713 ISM 3113 1-2008 1-2008 4756 Collins 2714 ISM 4212 ISM 4930 2715 COURSE (CourselD, CourseName) REGISTRATION (StudentID, SectionNo, Semester) SectionNo CourselD CourseName StudentID Semester ISM 3113 ISM 3112 ISM 4212 Syst Analysis Syst Design Database Networking 38214 54907 54907 2714 1-2008 1-2008 1-2008 2714 2715 2713 ISM 4930 66324 1-2008

Step by Step Solution

★★★★★

3.20 Rating (167 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Database descriptions A particular SQL system may restrict the length of column names or may not per... View full answer

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 Essentials Database Management Questions!

Write a structural formula for each of the following compounds, using a line to represent each single bond and dots for any unshared electron pairs: a. CH3OH b. CH3CH2Cl c. C3H8 d. CH3CH2NH2 e. C2H5F...

Write a balanced equation for each of the following reactions: (a) Preparation of white phosphorus from calcium phosphate, (b) Hydrolysis of PBr3 (c) Reduction of PBr3 to P4 in the gas phase, using...

Write a balanced equation for each of the following reactions: (a) Hydrolysis of PCl5 (b) Dehydration of phosphoric acid (also called orthophosphoric acid) to form pyrophosphoric acid, (c) Reaction...

Please complete question 1 Problems and Exercises 1 through 9 are based on the class scheduling 3NF relations along with some sample data shown in Figure 6-11. Not shown in this figure are data for...

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

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:

5 - 3 4 . 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...

1. Write a database description for each of the relations shown, using SQL DDL. 2. Write SQL data definition commands for each of the following queries: a) How would you add an attribute, country...

8. Write SQL queries to answer the following questions: A) Which students are enrolled in both Database and Networking? (Hint: use SectionNo for each class, so that you can determine theanswer from...

The ligure shows gi - y ou the lefl aul lliux versus MIMF ou rigtil. Assune 450 turra. 1. Drsw the o(t) on the sppropriste place, 2. Drive the nguselizntion current fron Ibe twa ligures given? 200-...

From the 2010 GSS subsample, we find that 72.7% of respondents believe in some form of life after death (N = 1,500). a. What is the 95% confidence interval for the percentage of the U.S. population...

Reduction of risk through owning a variety of different types of assets is covariance. diversification. correlation. unsystematic risk.

The U.S health care supply chain depends heavily on other nations. TRUE OR FALSE

Calculate by hand 8.625 10 1 divided by -4.875 10 0 . Show all the steps necessary to achieve your answer. Assume there is a guard, a round bit, and a sticky bit, and use them if necessary. Write...

Calculate (3.984375 10 - 1 + 3.4375 10 -1 ) + 1.771 10 3 by hand, assuming each of the values are stored in the 16-bit half precision format described in Exercise 3.27 (and also described in the...

Calculate 3.984375 10 -1 + (3.4375 10 -1 + 1.771 10 3 ) by hand, assuming each of the values are stored in the 16-bit half precision format described in Exercise 3.27 (and also described in the...

Dixie Dynamite Company is evaluating two methods of blowing up old buildings for commercial purposes over the next five years. Method one (implosion) is relatively low in risk for this business and...

Islamic Finance focuses on O Interest of individuals consumers and individual producers and their utility and profit maximization respectively even at the cost of the harms to others O Shared...

E. What is Cass's total return for the year? 10. On February 1, 2013, Janet buys a bond for $10,000 that makes coupon payments of $600 after each of the following two years and returns its principal...