Design a set of database tables to store information

Assignment Help Computer Engineering

Reference no: EM132118930

Read chapter 24 of Big Java 6th Ed. (on the BlackBoard course website as a PDF) and provide short answers to the following questions. Submit your answers in a text document (plain text or Microsoft Word format, please).

a. Design a set of database tables to store information about classes and instructors for the classes. For this question, an instructor has a unique ID number (such as 123456), a name (such as "John Doe"), and an email address . Every class has a unique course identification number (such as "MIS307"), course name (such as "College of Business"), number of credits (such as 3), and instructor's ID number. Any one instructor can teach multiple classes.
Show the CREATE TABLE statements that could be used to create these two tables.

b. Give the SQL command to INSERT an instructor "John Doe" with ID number 123456 and email address "[email protected]" into the instructor table you showed how to create in (a) above.

c. Give the SQL command to INSERT a course number "MIS307" in the College of Business with 3 credits taught by instructor ID 123456 into the class table you showed how to create in (a) above.

Reference no: EM132118930

Questions Cloud

What is the concept of globally right source : What is the concept of Globally Right source and how can an organization use this to add value to their activities to increase their competitive positions?

Creating a strategic plan : What are some of the legal issues a company face when creating a strategic plan?

What questions would you ask the heads of the six business : What advantages would the proposed Advanced Mobile Communications and Information System provide for Whitman Price Consulting?

Risk-averse-risk-neutral and risk-seeking : Provide examples of real organizations that represent each level of risk tolerance: risk-averse, risk-neutral and risk-see

Design a set of database tables to store information : Design a set of database tables to store information about classes and instructors for the classes.

Future value and compound interest formula : Find the future value and compound interest. Use the? $1.00 future value table or the future value and compound interest formula.

Learning facilitation methods : What are the advantages of action learning sets when compared with other learning facilitation methods?

Compute the suffix array for the same string : Does this change the memory requirement of suffix array and BWT? What impact it might have on suffix trees?

Feedback on the performance of team members : How does collecting regular feedback on the performance of team members, from relevant sources assist managers in identifying the learning needs of individuals

User Account

All Pages