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
The Enhanced Entity Relationship Diagram (ERD) produced with a drawing or case tool. Your EERD must use a ''standard'' notation style such as Crows Foot or Chen. Please note that t

Determine the Persistent object Persistent object can be stored in one of the following: Files Cheap, permanent, simple storage Low level (Write, Read) Ap

how oracle can be used

What is meant by log-based recovery? The most widely used structures for recording database changes is the log. The log is a sequence of log records, recording all the update a

Differance between DDL and SDL? DDL and SDL - The data definition language (DDL) is used through DBA and database designers to describe internal schema, conceptual schema, and

Assume you are given a uniprocessor system with one gigabyte of memory and a 300 gigabyte disk. The OS on the machine has a demand paged virtual memory system with a local page rep

Differentiate between Key and superkey? Key and superkey - A key a single attribute or a combination of two or more attributes of an entity set in which is used to identify o

NEED FOR A DATABASE MANAGEMENT SYSTEM A Database is a structured, persistent collection of data of an organisation. The database management system (DBMS) manages the database o

Question: (a) One of the steps in the five-step problem-solving model is implementation. Implementation is considered a key step in the problem-solving model. A problem may be

Construct an ER diagram for a hospital along with a set of patients and a set of medical doctors Associate with every patient a log of the several tests and examinations conducted.