Use sql to create database

Assignment Help Database Management System

Reference no: EM1371979

Use SQL to create the following database; to including referential integrity. You may NOT use the GUI for this part of the exercise.

COURSE ( CourseNu, CourseName, CreditHrs)
SECTION ( CallNu, Semester, Year, BuildName, RoomNu, EnrollmentMax)
STUDENT ( SID, SName, SAdd, STelephone)
INSTRUCTOR ( IID, IName, IRoomNu)

Courses have sections; each section is associated with one course. Students enroll in sections, but each section may only have that student enrolled once. Instructors teach sections. There is NO team teaching.

Reference no: EM1371979

Questions Cloud

Determining adolescents : Based on adolescents who act out, what would be some theories in addressing children who act out as it relates to strategies of family therapy.

Direct and indirect violence : I need assistance with understanding direct violence, indirect violence (structural violence and cultural violence), and positive/negative peace.

Find an expression for the marginal product of labor : Assume capital is fixed at 16 units. If the company can sell its output at a price of $100 per unit and can hire labor at $25 per unit,

Attitude toward living in the global village : What is your attitude toward living in the global village? Explore this attitude; why do you think you feel the way you do?

Use sql to create database : Use SQL to create the following database; to including referential integrity. You may NOT use the GUI for this part of the exercise. COURSE ( CourseNu, CourseName, CreditHrs).

Design pseudocode and flowchart for swallowing a pill : Write a solution in pseudocode for swallowing a pill. Translate solution into flowchart. Write about which tool they like best and why? Which tool do they think would be easiest to learn?

Calculate marginal and average products : The following table shows information for a simple production function. From the data in the table, calculate marginal and average products.

Production isoquants and isocost line : A company uses two inputs to produce a final good. If the price of one of the inputs raise and price of the other remains the same

Economic gender inequality : What are some steps that may be taken to remedy the problem of economic gender inequality? Will equal pay for the same job be enough to solve the problem?

User Account

All Pages