Example database application, Database Management System

We will explain here an example database application having COLLEGE database and use it in showing several E-R modelling concepts.

College database remains track of faculty, Students, Departments and Courses organised by several departments. Following is the explanation of COLLEGE database:

College have several departments like Department of Hindi, Department of English, and Department of Computer Science etc. Every department is assigned a unique id and name. Some faculty members are also appointed to each department and one of them works as head of the department (HOD).

There are several courses conducted by every department. Each course is assigned a unique id, name and duration.

  • Faculty information has name, address, department, basic salary etc. A faculty member is assigned to only one department but can teach several courses of other department also.
  • Student's information contain Name, Roll no (unique), Address etc. A student can opt only for one course.
  • Parent (guardian) information is also kept along with every student. We keep each guardian's name, sex, age, and address.
Posted Date: 3/6/2013 5:59:21 AM | Location : United States

Related Discussions:- Example database application, Assignment Help, Ask Question on Example database application, Get Answer, Expert's Help, Example database application Discussions

Write discussion on Example database application
Your posts are moderated
Related Questions
Explain the paths in the association network We can analyze use of paths in the association network as given below: Calculate each operation Find associations whic

Serialisable Schedules: If the processes of two transactions conflict with each other, how to verify that no concurrency related problems have happened? For this, serialisability t

What is a value? A data value is used for identity. This form of identity is used in relational systems.eg: The primary key value of a tuple recognize the tuple.

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

Develop Database academic assignment Project Description: For a provided set of instructions in a case study design Entity Relationship Diagram. - Entity Relationship Diag

Advantages of Observation  Methods: Bailey has pointed  out four  advantages of observation: 1. Superior in Data  Collection  on Non Verbal Behavior: When  a person  a opi

What are the two types of blocks in the fixed -length representation? Define them. Anchor block: Have the first record of a chain. Overflow block: Have the records other tha

In this exercise you will create ten records, each containing the following fields: student name, class:  Freshman, Sophomore, Junior or Senior, Major:  Liberal Arts or General Sci

Atomicity : Either all functions are laid out or none are. Users could not have to think about the effect of incomplete operations. DBMS ensures this by undoing the functions

please describe the data base management with the easy example &give the application?