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
Let us now make the E-R diagram for the student database as per the explanation given in the previous section. We can also states the overall logical structure of a database usi

(a)    Provide the description of the following ODMG schema in the Object Definition Language (ODL). (b)   Based on the above object database, write the following queries i

Differentiate between horizontal & mixed horizontal fragmentation?

Is it mandatory to declare all the tables in Report by the key word tables for all the tables that exist in the structure of LDB, and are being explained in the Database part of LD

A field-groups statement or an insert statement reverses storage space and transfers values. False.

Which two tools are used to administer users for Active Directory?

Construct a generalization-specialization hierarchy for a motor-vehicle sales company. The company sells motorcycles that comprise an engine number and cost; cars that have a chass


Explain how you can define an object model of a system. A list of terms that shall be used by end users to describe state and behaviour of objects in system.   Different use

What are the three data anomalies that are likely to occur as a result of data redundancy?  Can data redundancy be completely eliminated in database approach?  Why or why not? A