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
What is catalog in DBMS? Catalog - A relational DBMS maintains information about every table and index in which it contains. A catalog is a collection of special tables that st

What is Interaction Diagram An interaction diagram shows an interaction, comprises of a set of objects and their relationships including the messages that may be dispatched be

Create 1 experiment to demonstrate an aspect of query optimisation by using access-path structures (indexes), decomposition, or denormalisation. Once satisfied with your experiment

Your friend owns a computer store in Yuen Long, selling Desktop and Notebook PCs and other computer peripherals. Having been rather successful with his business there, he decided t

Which sorting technique is used to sort databases, whose sizes are very big?  Give one such algorithm.  Why do sorting techniques like quicksort, insertion sort, etc.  not applied

statical data

let us consider a table having 2200 records and the fixed size of the table to be considered as 25.then how many numbers of table is requredto perform horizontal fragmentation

What are the ways of obtaining the connection parameters?  Hardwire the parameters into the program. Ask for the parameters interactively. Get the parameters

#quCreate a database design specification (Enhanced Entity Relationship Diagram (EERD) and Relational Data Model (RDM)) from the given business description. The RDM must be in 3rd

What is the use of sub queries? A sub query is a select-from-where expression that is nested with in another query. A common use of sub queries is to do tests for set membershi