Design the appropriate er-schema diagram

Assignment Help Database Management System

Reference no: EM132087288

Oracle International is offering a set of certified programs in different tracks (Fundamentals, Design, Development, Administration, Application, ... etc).

Each program is described by a unique code and a unique title. Each program is structured as a set of core courses and a set of elective courses.

A course may be offered through several programs but not necessarily with the same nature (a course can be core for some programs but elective for others).

Each course is described by a code number (unique) title, description, and number of credit hours. It is required to keep track of the total required credit hours and total elective credits hours for each program. A student may enroll in more than one program and take several courses of these programs.

A student is considered registered in a program if he/she is already enrolled in at least one the courses of that program.

A student is described by a unique Id, name, address, birth date, and Email address. It is required to keep track of the grade of each student in each course of each program.

Design the appropriate ER-schema diagram for the given data requirements Specify all key attributes and all structural constraints.

Give also the corresponding relational schema.

Specify all integrity constraints for each defined relation.

ER Schema Diagram

Relational Schema Diagram

How would be the ER and the relational schemas for the same data requirements but with the constraint: each course is offered by only one program? You can show on the changes in both the ER and Relational Schemas.

Reference no: EM132087288

Questions Cloud

Calculate the rate constant k : In a university laboratory experiment the rate of disappearance of ozone (O3) was measured to be 9 x 10-3 M/s. Simultaneously, the concentration of ozone

List the isbn and title of books published by the publisher : Display the title and publisher of the most expensive book based on the retail price.

Create trigger on update of chairid that enforces : Create trigger on update of chairID that enforces the following business rules One employee can chair no more than one department.

Causes the rate of formation of a : Tripling the initial concentration of X causes the rate of formation of A to be increased by a factor of 9.

Design the appropriate er-schema diagram : Design the appropriate ER-schema diagram for the given data requirements Specify all key attributes and all structural constraints.

Calculate the amount concentration of the original silver : Based on your observations, what substance is the excess reagent? Identify the evidence that supports this.

Determine the unknown voltages for each circuit : Determine the unknown voltages for each circuit - calculate the voltage gain for each stage and the overall voltage gain. Assume the op-amps to be ideal

Calculate the mole fraction of bromine in water : Calculate the mole fraction of bromine in water in both solutions below, and the molality of bromine in both solutions presuming that the density of water.

What is the symbol or name being defined here : In order to protect a library's interface file from being included multiple times, we always put in three special preprocessor directives.

User Account

All Pages