Lovely Professional University 2011 B.Tech Computer Science and Engineering Design problem- database management system - Question Paper
Problem:
A database is to be designed for a University to monitor students' progress throughout their course of study. The students are studying for a degree (such as B.Tech, B.Tech (Hons) MCA, etc) within the framework of the modular system. The University provides a number of courses, every 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 1 or more lecturers. A lecturer may teach more than 1 course. Students are free to select any course they wish but the subsequent rules must be observed: a few courses require pre-requisites courses and a few degree programs have compulsory courses. The database is also to contain a few info about students including their numbers, names, addresses, degrees they learn for, and their past performance (i.e. courses taken and exam results).
Represent the complete scenario with the help of ER Diagram and design logical schema for this database. Also specify desirable constraints and justify your design approach even in a single small step.
|
Design Problem1
School:LHST-A Department:CSE/IT Name of the faculty member: Jaspreet Course No: CSE351 Term: II Max. Marks:20 Date of Allotment: 02-02-2011 Date of Submission:16-02-2011
Problem:
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. Note: Assumptions can be made wherever necessary.
|
|
|
| Earning: Approval pending. |
