Convert er diagram into relational schema

Assignment Help Database Management System

Reference no: EM1360083

1. Suppose we are to design a registrar's database to store information about students, courses, the courses students have taken, and the grades students have gotten in these courses. Courses have a number, a department, and a title, for example, "CS101: Introduction to computing" has department = CS, number = 101, and title = "Introduction to Computing." Numbers are assigned by departments, and different departments may use the same number. Students are represented by their (unique) student ID and their name. "Enrollments" each consist of a course, a student who took that course, and the grade the student got in the course.

a. Draw an E/R diagram that represents this database structure correctly.

b Convert the E/R diagram of part a into a relational schema.

Reference no: EM1360083

Questions Cloud

Electronic funds transfers and value of money : There is often a number of people in the world that do not actually see the value of a dollar anymore. The fact that a person can go up to an ATM and withdraw any amount of cash.

Perform an effective pra within healthcare organizations : Explain what are the different types of methods that can be used in order to perform an effective PRA within healthcare organizations?

Insurance company financial risks : Which of the following insurance company financial risks would be the most concerning to you as a risk manager:

Prepare a career development plan for an organization : what courses would you design and offer to employees that could increase skill level and possibly open up other opportunities for them within the organization?

Convert er diagram into relational schema : Suppose we are to design a registrar's database to store information about students, courses, the courses students have taken. Convert the E/R diagram into a relational schema.

Estimate the firms projected needs : In November of each year the CFO of Barker Electronics starts the financial forecasting process to estimate the firm's projected needs for new financing during the coming year.

Organizations guiding principles : Expalin why are values referred to as an organization's guiding principles? In what sense do values constitute a directional strategy for the organization?

Case study of human sexuality : Identify and describe the concept or concepts in the scenario using correct terminology from the course. If the concept is closely associated with the writings of a particular theorist

Explain some additional research on employee motivation : Explain Do some additional research on employee motivation and come up with your own motivational theory based on what you learn from the theorist that have come before you

User Account

All Pages