Er diagram to monitor students-write desirable constraints

Assignment Help Software Engineering

Reference no: EM1368667

Ddatabase 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: EM1368667

Questions Cloud

Prove-leaves of binary search tree are located in bottom : Examples for small n are given bellow, where a small square box represents an unsuccessful search. Prove that leaves of any binary search tree are located in the bottom two levels.

Calculate gross domestic product : In a simple economy assume that all income is either compensation of employees or profits. Suppose also that there are no indirect taxes. Compute gross domestic product from the following set of numbers.

Define product innovation and process innovation : Define product innovation, process innovation and radical innovation and Given your preferred leadership style which innovation type do you believe your style is most favorable for strategic success?

Income and substitution effects : After Iraq invaded Kuwait, gasoline prices increase dramatically--up to 50 percent. There were many effectrs of the increased price of gasoline.

Er diagram to monitor students-write desirable constraints : Represent entire scenario with the help of ER Diagram. Also write desirable constraints and justify your design approach even in a single small step.

Show the flexibility in hr management beneficial : How is flexibility in human resources management beneficial? How is it detrimental? What are the greatest challenges in hiring and firing employees?

Analyzing marginal rate of substitution : Let commodity 1st be bottled water, measured in gallons. Commodity 2nd denotes plain tap water, also measured in gallons.

Prepare a presentation for the chamber of commerce : Prepare a presentation for the Chamber of Commerce of an area of your choice and Purpose: To give business leaders an idea of what the economy may look like based on recent history and expected future conditions

Calculate m mod p in rsa cryptosystem : Assume that instead of using composite N = pq in RSA cryptosystem, we simply use prime modulus p. Calculate m mod p. Justify correctness and analyze running time of decryption algorithm.

User Account

All Pages