If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Database modelling need answers for this

Suppose for a college database, there was a Course entity, which specified name, id, description, etc. Later we needed to specify location, time, semester, etc. We decided to create a Class entity. This new entity included everything what was in the Course entity plus added all other data. Also at first we had a Student entity to represent all students in the college. Later we decided to be more specific and to further describe students as full time or part time. Where is generalization and where is aggregation in these two cases? Why?

A university consists of a number of departments, department will be identified by department no, its respective name, number of course it offers. Each department offers several courses, each of the course is identified by its respective course code, course name, and its respective module it belongs to. A number of modules make up each course, each of the module is identified by its module code, module name, credit for each module. Students enrol in a particular course and take modules towards the completion of that course, students will have their student id, student name, department they belongs to, course they registered for, module they study. Each module is taught by a lecturer from the appropriate department, and each lecturer tutors a group of students, here each of the lecture is identified by their lecture number, department they belongs to, course and module they are teaching. Draw an ERD showing the description above.

Suppose for a college database, there was a Course entity, which specified name, id, description, etc. Later we needed to specify location, time, semester, etc. We decided to create a Class entity. This new entity included everything what was in the Course entity plus added all other data. Also at first we had a Student entity to represent all students in the college. Later we decided to be more specific and to further describe students as full time or part time. Where is generalization and where is aggregation in these two cases? Why?

The generalization is at (or more accurately just after) 0x0020. The Aggregation only occurs in the queries, signaled by the use of an aggregate function.

-PatP

In theory, theory and practice are identical. In practice, theory and practice are unrelated.