Create single conceptual erd showing entity-s primary key

Assignment Help Software Engineering

Reference no: EM1369100

1. Produce a single Conceptual ERD (on a single slide) for the whole Case Study showing all attributes and identifying each entity's primary key.

2. Clearly and concisely state any assumptions (decisions) you have made on a single and separate slide.

School of computing case
Scenario

Students at Weatherfield University School of Computing are, at any one instance in time, enrolled on an award. The school has around 50 modules. An award is made up of either 12 or 16 modules. Between six and eight are core modules (depending on the particular award), the remainder of the award is constituted from a number of specified "elective" modules which students choose (to make up their award).
Each module is taught by one or more members of academic staff, one being designated the "Module Leader" responsible for organising the teaching team, planning the teaching schedule, etc. A module also has a "Moderator" who is responsible for assuring the quality of module; a member of staff cannot be both the Leader and Moderator for a particular module.
Academic staff are one of the following: Lecturer 1, Lecturer 2, Senior Lecturer, Principal Lecturer or Reader, Professor. There is also a dean who is the school head, reporting to him are four Principal Lecturers and all other academic staff report to one of these Principal Lecturers, with the exception of Professors who report directly to the Dean.

Reference no: EM1369100

Questions Cloud

Effects of ms and md : Explain briefly how a change to the following MS, MD, or P would shift LM function to right. Include in your discussion whether the variable would have to increase or decrease to cause the rightward LM shift.

Dual-core approach management vs technology : Explain the dual-core approach. How does the process of management change normally differ from technology change and discuss

What is an angular acceleration if wheel started from rest : A wheel moves forward for 2 seconds making two complete revolutions. The wheel rotates during an arc length of 8.2 meters.

Explain effects of monetary policies on economy production : Explain effects of monetary policies on economy's production and employment. Cite your references appropriately. If you used an electronic source, include URL. If you used a printed source please attach a copy of data to your paper.

Create single conceptual erd showing entity-s primary key : Create single Conceptual ERD (on a single slide) for entire Case Study showing all attributes and identifying each entity's primary key.

Who are the stakeholders affected by the stores decisions : Who are the stakeholders affected by the stores' decisions? Do the stores, as businesses, have an obligation to the broader community to not hurt tourism and Is Neda placing her own personal ethics ahead of business ethics? Is there a difference? ..

How much time elapses between first and second splash : Heather and Jerry are standing on a bridge 45m above a river. Heather throws a rock straight down with a speed of 19m/s. Jerry, at exactly the same instant of time, throws a rock straight up with the same speed. Overlook air resistance. How much t..

Which of following statements represent short comings : Some Keynesian economists criticize official unemployment statistics for understating extent of joblessness in United States. Which of following statements represent short comings of official unemployment rate reported by Bureau of Labour Statisti..

Importance of peer and supervisor support : Importance of peer and supervisor support - Why are peer support and supervisor support important to the transfer process?

User Account

All Pages