Relationship for college database, Database Management System

Using the concepts defined previous, we have identified that strong entities in COLLEGE database are FACULTY, STUDENT, COURSE and DEPARTMENT. This database also has one weak entity known as GUARDIAN. We can states the following relationships:

1. Head-of is a 1:1 relationship among FACULTY and DEPARTMENT.

Participation of the entity FACULTY is partial since not all the faculty members participate in this relationship, as the participation from department side is total, as every department has one head.

2. Works_in, is a 1:N relationship among DEPARTMENT and FACULTY.

Participation from both sides is total.

3. Opts, is a 1:N relationship among COURSE and STUDENT. Participation from student side is total because we are assuming that every student enrolled opts for a course. However the participation from the course side is partial, as there can be courses that no student has opted for.

4. Taught_by, is a M: N relationship between FACULTY and COURSE, as a faculty can teach a lot of courses and a course can be taught by a lot of faculty members.

5. Enrolled, is a 1: N relationship among STUDENT and DEPARTMENT as a student is allowed to enroll for only single department at a time.

6. Has, is a 1:N relationship among STUDENT and GUARDIAN as a student can have more than one local guardian and one local guardian is supposed to be related to one student only. The weak entity Guardian has total participation in the relation "Has".

Posted Date: 3/6/2013 6:21:56 AM | Location : United States







Related Discussions:- Relationship for college database, Assignment Help, Ask Question on Relationship for college database, Get Answer, Expert's Help, Relationship for college database Discussions

Write discussion on Relationship for college database
Your posts are moderated
Related Questions
Consider the subsequent relation   Professor (Pfcode, dept, head, time)   It is assumed that      (i) A professor can work in much more than one

What it creates while a primary key is combined with a foreign key? It creates Parent-Child relation ship between the tables that connect them while a primary key is combined w

What three major types of actions includes databases? Briefly discuss these The three major types of actions including databases are: (i) Defining: It includes specifyin

ADVANCE OBJECT DESIGN Introduction Analysis is the initial step of the OMT methodology. It is apprehensive with devising a precise, concise, correct and understandable mo

Demonstrate your knowledge of PL/SQL programming by writing and thoroughly testing triggers and stored procedures associated with an e-commerce application that provides security l

What is a PROJECT operation? The project operation is a unary operation that returns its argument relation with particular attributes left out. Projection is shown by pie (π).

Which database object does not physically exist? A view database object does not physically exist.

What is Cross Product? Simply Cross product is Binary Operator

which component of DBMS can be embedded in a program? The data manipulation language (DML) is a component which is embedded in a program.

1.Why we need data mining? Give an example to illustrate your answer. 2. Why data mining is considered as "misleading name"? 3. Distinguish the difference between database an