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

#### 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?

### Write a Review

#### Implement direct-address table keys of stored elements

Suggest how to implement direct-address table in which keys of stored elements don't require to be distinct and elements can have satellite data.

#### Advantages and inconveniences of new relational scheme

Compare activity (quite theoretical) of the disk (in number of bytes) required for each of both relational. Write down the advantages and inconveniences of new relational scheme.

#### Find average number of books borrowed from database table

Find the average number of books borrowed per member. Take into account that if a member does not borrow any books, then that member does not appear in the borrowed relation at all.

#### Data dictionary serves as important data management tool

The data dictionary serves as an important data management tool by? assigning attributes to the data, maintaining data in updated form.

#### Create entity-relationship diagram for bookstore database

Create Entity-Relationship diagram for a bookstore database, that maintains information about books, professional journals, their authors, and publishers.

Design an updateable database for storing customer and sales data. Explain how to deal with the problems of missing data.

#### Explaining business activity in new is with a database

Assume you manage business activity which needs a new IS with a database. The development team is divided on which DBMS you must use. One faction wishes to use oracle,a second wants to use MtSQL, and a third wants to use SQL server.

#### Write down responsibilities of database administrator

Write down the responsibilities of the database administrator (DBA)? Could you outline tasks that he/she has to perform, and what could be consequences if these matters are not handled?

#### Explain meaning of expression acid transaction

What is lock granularity? Explain the use of BEGIN, COMMIT, and ROLLBACK TRANSACTION statements. Explain the meaning of expression ACID transaction.

#### Access values through queries to databases

However, the only way you can access values is through queries to the databases. In single query, you can specify value k to one of two databases.

#### Explain primary problem in credit card records

You have a file which contains credit card records. Each record contains field for the card number, expiration date, and name of card holder. Explain what primary problem you try to solve is.

#### First - second or third normal form

How many entities are shown by this relation?