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
The C_Artist  application will be developed using the C language (C99 standards) and will be able to compile without warnings and link and run in the Swinburne computer laboratorie

What are the advantages of embedded query language? Give an example of an embedded SQL query. Embedded query language - SQL could be implemented within two ways. It can be us

Define the Attribute Inheritance The attributes of a higher level entity set are inherited through a lower level entity set made by specialization-generalization hierarchy. Nam

What do you mean by Correlated subquery? Subqueries, or nested queries, are used to bring back a set of rows to be used by the parent query. Depending on how the subquery is writ

What is the full form of ODBC ? ODBC stands for Open Database Connectivity.

Attributes that are directly kept in the data base. For example, 'Birth date' attribute of a person.   Derived  Attributes that are not stored directly but can be derived

A constraint named less_than_20 was defined on the field date_of_birth of table student. Delete this constraint. ALTER TABLE student DROP CONSTRAINT less_than_20;

State your technical objectives for mining the data. Data Understanding. Describe the data For each attribute, give its description and data type. For numeric attributes

What is a records management consultation? Our organization is an authority for disseminating your specific requirements and giving you with a solution to effectively manage yo

After going by the database architecture, let us now dwell on an important query: how is the data organised in a database? There are a lot of basic structures that exist in a datab