Create database for university to monitor students

Assignment Help Database Management System

Reference no: EM1367955

A database is to be designed for a University to monitor students' progress throughout their course of study. The students are reading for a degree (such as BTech, BTech(Hons) MCA, etc) within the framework of the modular system. The University provides a number of courses, each being characterized by its code , title, credit value, course coordinator, teaching staff and the department they come from. A course is co-ordinated by a course coordinator who shares teaching duties with one or more lecturers. A lecturer may teach (and be a course coordinator for) more than one course. Students are free to choose any course they wish but the following rules must be observed: some courses require pre-requisites courses and some degree programs have compulsory courses. The database is also to contain some information about students including their numbers, names, addresses, degrees they read for, and their past performance (i.e. courses taken and examination results).

Represent the complete scenario with the help of ER Diagram (use maximum advanced features) and design logical schema for this database. Also specify desirable constraints and justify your design approach even in a single small step.

Reference no: EM1367955

Questions Cloud

Determining optimal combination of labor-capital : Crew Brew produces a popular brand of beer in its mini-brewery located on a small river in Kentucky. Assume that capital can be purchased for $8 per unit, and labor costs $6 per unit. What is the optimal combination of inputs for the firm to employ..

Decrease of labor force in nursing : You have just been mandated to decrease your department's labor force by eight percent.

Decreasing the ethical conflicts : National Products Company participates in a highly competitive industry. In order to meet this competition and to get profit goals, the corporation has chosen the decentralized form of organization.

Maximizing profit in separated markets : Ann McCutcheon is hired as a consultant to a firm producing ball bearings. This firm sells in two distinct markets, each of which is completely sealed off from the other. What price should managers charge in each market?

Create database for university to monitor students : A database is to be created for University to monitor students' progress throughout their course of study. Students are reading for degree (such as BTech, BTech(Hons) MCA, etc) within framework of modular system.

Illustrate what happens to consumer surplus into market : Assume bad wear in Florida ruins much of orange crop. Illustrate what happens to consumer surplus into market for oranges.

Business question on profit maximization : What is the level of newspaper and magazine advertising that maximizes the firms sales and what is the firms sales at the optimal values of newspapers and magazine advertising determined in part 1?

Determine firm profit-maximizing output : Suppose that perfectly competitive firm faces the market price (P) $5 per unit, and at this price the upward-sloping portion of the firm's marginal cost curve crosses its marginal revenue curve at an output (Q) level of 1,500 units.

Illustrate what is inflation.and what is deflation : Illustrate what are different types of unemployment and how do they affect economy. Illustrate what is inflation. Illustrate what is deflation.

User Account

All Pages