Question: Create a Courses table Primary key is CourseId an integer which is to be generated Other attributes include: course Number (e.g.CS1103), courseName,courseDescription, and credit Hours.

Create a Courses table

Primary key is CourseId an integer which is to be generated

Other attributes include:

course Number (e.g.CS1103), courseName,courseDescription, and credit Hours.

make sure that credit hours is within the range of 0 to 6 and has a default value of 3

Use Insert (or Delete) statements to test your constraints.

Add an approvedDate attribute to the Course table

Use Insert (or Update) statements to add (or update) data

to the table with the extra attribute

Write and run an SQL statement that for each student lists the information for

courses theyve taken and their letter grade.

(can I have the codes that needs to be done and the sql queries), to solve this question.

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!

Q:

Draw a class diagram, showing the relevant classes, attributes, operations, and relationships for each of the following situations (if you believe that you need to make additional assumptions,...

Q:

Draw a class diagram, showing the relevant classes, attributes, operations, and relationships for each of the following situations (if you believe that you need to make additional assumptions,...

Q:

Draw a class diagram, showing the relevant classes, attributes, operations, and relationships for each of the following situations (if you believe that you need to make additional assumptions,...

Q:

VALLEY FURNITURE DELIVERY DATA MODELING ASSIGNMENT MGMT 4013 TC1, Spring 2018 Your assignment is to create a data model based on the scenario and data below. For your convenience, I have included the...

Q:

Please I want the second and third part of the assignment. thanks First, Create a C# Console project named YourInitialsAsn1 (such as hpAsn1 for a student named Harry Potter). Use the Solution...

Q:

Study Guide Strategic Business Management By A. J. Cataldo About the Author A. J. Cataldo is currently a professor of accounting at West Chester University, in West Chester, Pennsylvania. He holds a...

Q:

Summerize it in 300 words AN ACADEMIC PROGRAM PROFILE: WAYNE STATE UNIVERSITY Ingrid Guerra-Lopez Tim Spannaus Siba Dallal Introduction by Sung "Pil Kang, PhD, and Yeol Huh, PhD, Column Editors Since...

Q:

the concept of minimum cardinality, or the minimum number of entities required in any given relationship is a difficult concept to grasp. Let me try to walk through an example that I hope will help....

Q:

Hello, Would you please review the attached assignment? I know I have errors in and this assignment carries into the rest of the course so I need to get it corrected to move forward. I have attached...

Q:

Hello, Would you please review the attached assignment? I know I have errors in and this assignment carries into the rest of the course so I need to get it corrected to move forward. I have attached...

Q:

When securities are fairly priced, why would the original shareholders of a firm pay the present value of bankruptcy and financial distress costs?

Q:

Can you help me with this problem, please? CHALLENGE QUESTION MATCHING Determine the correct type of enzyme that will catalyze the reactions described in the following statements. An enzyme that uses...

Q:

A household inventory should be stored in a home office. True Fatse

Q:

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

Q:

Answer parts a and b, below, on the basis of the following information for a hypothetical economy in year 1: money supply $400 billion; long-term annual growth of potential GDP 3 percent; velocity

Q:

KEY QUESTION Use an AD-AS graph to demonstrate and explain the price-level and real-output outcome of an anticipated decline in aggregate demand, as viewed by RET economists. (Assume that the economy...

Q:

KEY QUESTION Suppose that the money supply and the nominal GDP for a hypothetical economy are $96 billion and $336 billion, respectively. What is the velocity of money? How will households and...