Question: Write SQL commands that will (a) create a table called Qualified with fields: FacultyID numeric size 4 CourseID alphanumeric size 7 DateQualified standard date format.

Write SQL commands that will

(a) create a table called Qualified with fields:

FacultyID numeric size 4

CourseID alphanumeric size 7

DateQualified standard date format. YYYY/mo/day

(b) which field did you select as the primary key? Why?

(c) that will add FacultyID 2144, CourseID ISM3144, DateQualified 2016/09/23

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:

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

Q:

I am terrible at access and not sure on how to write the formulas. I have done what is in yellow. Can someone help this is due Friday at 10am Central Time. Attached is the rubric and all of the...

Q:

I am terrible at access and not sure on how to write the formulas. I have done what is in yellow. Can someone help this is due Friday at 10am Central Time. Attached is the rubric and all of the...

Q:

Draw a total setup outline and decide the expense for the most economical design, i.e., the one where the complete expense of the correspondences circuits and equpment is the least. (b) The...

Q:

Hi, I have areport due in nine hours. I need to find the following list of things on Amazon.com....

Q:

Could I get the cost of capital calculation (WACC) broken out in excel for Amazon based on FY2015 financials? \fTo our shareowners: This year, Amazon became the fastest company ever to reach $100...

Q:

BATCH 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67...

Q:

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

Q:

Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...

Q:

Worksheet Objectives Become familiar with the file system directory tree used in class Determine the current working directory with the pud command . Use the ls (list files) command with various...

Q:

Blues Music Center had the following petty cash transactions in March of the current year. March 5 Wrote a $ 250 check, cashed it, and gave the proceeds and the petty cashbox to Jen Rouse, the petty...

Q:

You are the auditor of Cocona Fans Manufacture Inc. ("Cocona") and are in the process of completing the audit for the year ended 31 December 20x0. You note the following two outstanding matters upon...

Q:

Which of the following statements is correct? A ) The federal dividend tax credit is equal to 6 / 1 1 of the gross up on eligible dividends received. B ) The federal dividend tax credit is equal to 1...

Q:

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

Q:

Explain the purpose of the Project Charter and its relationship to Management Approval for a Project.

Q:

What is Change Control and how does it operate?

Q:

How do Data Requirements relate to Functional Requirements?