Construct an e-r diagram for the registrars office in crows

Assignment Help Computer Engineering

Reference no: EM132154645

A university registrar's office maintains data about the following entities:

(a) courses, including number, title, credits, syllabus, and prerequisites;

(b) course offerings, including course number, year, semester, section number, instructor(s), timings, and classroom;

(d) instructors, including identification number, name, department, and title.

Further, the enrollment of students in courses and grades awarded to students in each course they are enrolled for must be appropriately modeled.

The assumptions made are:

a class meets only at one particular place and time. This ER diagram cannot model a class meeting at different places at different times.

There is no guarantee that the database does not have two classes meeting at the same place and time.

Construct an E-R diagram for the registrar's office in Crows Foot notations.

Construct appropriate tables for the ER diagram in Microsoft Access. Your Access database should show relationships between the tables.

Construct a Use Case diagram in Visio or LucidChart.

You can use Visio or LucidChart for the ER and Use Case diagrams. Provide your assumptions, explanation, and rationale in a Word document.

Reference no: EM132154645

Questions Cloud

Always on profit maximisation motive : One of the ways in which they should increase profits would be cut cost where possible and increase interest charges. Do you agree? Discuss.

Determine the effective memory access time in terms : The access time from the processor to either cache is c clock cycles, and the block is transfer time between the caches and main memory is b block cycles.

Compare intelligence and simulated intelligence : Analyse the meanings of intelligence and simulated intelligence. Compare intelligence and simulated intelligence.

What methods of training will be used to train stakeholders : BSBINM501 Manage an information or knowledge management system Assessment, Elite Education Vocation Institute, Australia. Who will develop training materials

Construct an e-r diagram for the registrars office in crows : The enrollment of students in courses and grades awarded to students in each course they are enrolled for must be appropriately modeled.

What is the price of the stock today : If the required return is 13 percent, what is the price of the stock today? (Do not round intermediate calculations and round your answer to 2 decimal places)

Calculate the expected change in the price : a) Calculate the expected change in the price of the bond if market interest rates FALL by 1.25%

Convert between us length and international length metrics : Write a Java GUI application to convert between US length metrics and the International length metrics.

What is the implied one year treasury rate : The 1 year treasury note is currently yielding 2.5%. What is the IMPLIED one year treasury rate one year from today?

User Account

All Pages