Represent system descriptional as an er diagram

Assignment Help Computer Engineering

Reference no: EM133324566

Assignment: The database must record details on students, courses, modules. grades and lecturers. Details recorded for each student include their name, address and date _ of birth. A student belongs to one o ours-e lonlly.' Attributes for a course include the course code and year. A student will eel est a number of modules. and a module Can be selected by a number of students A students January and summer grades are recorded for each module. A lecturer loan. teach one or more modules. A module can be taught by one or more lecturersTlne database records how many hours per week a lecturer spends teaching; sash Module.

a) Represent the system descriptional above as an Entity-Relationship ' Diagram. Ensure you have the correct cardinality and participation for each relationship. Include suitable attributes in your diagram. indicate any assumptions you have made.

b) Convert the 'ERD from part a) above to a relational model

Reference no: EM133324566

Questions Cloud

Discuss the potential impact of this project : Emphasize what is innovative about your proposed project. Discuss the potential impact of this project on your anticipated results to the betterment of health

How spirituality impacts patients/patient care : How spirituality impacts patients/patient care and Explain how culture and spirituality go together and Holistic medicine and its impact (nonpharmalogical)

Create an entity-relationship diagram for this system : Create an Entity-Relationship Diagram for this system. For each relationship in your diagram ensure you name it, and indicate cardinality and participation.

How can we collaboratively support homeless students : How can we collaboratively support homeless students in our schools and communities? How can we advocate for more training and continuing education to support

Represent system descriptional as an er diagram : Represent the system descriptional above as an Entity-Relationship ' Diagram. Ensure you have the correct cardinality and participation for each relationship.

Reflect on how you, as a nurse would respond to the type : Reflect on how you, as a nurse would respond to the type of abuse your patient has experienced. How should you respond

Ciwa protocol on medical surgical unit : NUR-329 William Paterson University Between physicians and nurses how would I as a nurse standardize the Ciwa protocol on my Medical Surgical unit

Give the binary microinstruction corresponding to each : Give the binary microinstruction corresponding to each of the following sets of micro-operations. Increment SP by 1. Store the results back in the SP.

Evidence found to support leadership principle : Identification main points Evidence found to support leadership principle- at least one piece of evidence Lead class discussion about lessons learned

User Account

All Pages