Showing posts with label Fundamentals of Database Management. Show all posts
Showing posts with label Fundamentals of Database Management. Show all posts

Saturday, 9 March 2013

Define the following terms. i. Database ii. Database Management System iii. Data Model iv. Schema v. Data Independence

Database:

A collection of related information stored in a structured format. Database is often used interchangeably with the term table (Lotus Approach, for instance, uses the term database instead of table). Technically, they're different: A table is a single store of related information; a database can consist of one or more tables of information that are related in some way. For instance, you could track all the information about the students in a school in a students table. If you then created separate tables containing details about teachers, classes and classrooms, you could combine all four tables into a timetabling database. Such a multi-table database is called a relational database..

What are the Roles and Responsibilities of database administrator?

The Database Administrator (DBA) is the super-user of the system.
The role of the DBA is very important and is defined by the following functions.

Ø  Defining the Schema
The DBA defines the schema which contains the structure of the data in the application. The DBA determines what data needs to be present in the system and how this data has to be represented and organized.