IMPORTANT TOPICS FOR FINAL PROJECT VIVA EXAM

IMPORTANT TOPICS FOR FINAL PROJECT VIVA EXAM

Ø  Database Management System

Ø  Entity Relationship Model

·         E-R Diagram

Ø  Keys (Relational Keys)

1)      Super Key

2)      Candidate Key

3)      Primary Key

4)      Alternate Key

5)      Composite Key

6)      Foreign Key

Ø  Relational Database Management System

Ø  Types of Relations

1.      Base Tables

2.      Query Results

3.      Views

Ø  Database Anomalies

Ø  Normalization

1)      First Normal Form

2)      Second Normal Form

3)      Third Normal Form

Ø  Joining

Ø  Relationship

                                I.      One-to-One Relationship

                             II.      One-to-Many Relationship

                          III.      Many-to-Many Relationship

• Black box testing  
• Structural testing (White box)

v  Before viva must read the CS304 (Object Oriented Programming) first 10 Lectures

Description

 

Relational Database Management System (RDMS)

A relational database is a database that can be perceived as a set of tables and manipulated in accordance with the relational model of data. It contains a set of data objects used to store, manage, and access data. Examples of such data objects are tables, views, indexes, functions, triggers, and packages.

Most of today's database systems are referred to as a Relational Database Management System (RDBMS), because of their ability to store related data across multiple tables.

Relational databases are designed for fast storage and retrieval of large quantities of data.

 

What is RDBMS?

RDBMS stands for Relational Database Management System. RDBMS is the basis for SQL, and for all modern database systems like MS SQL Server, IBM DB2, Oracle, MySQL, and Microsoft Access.
The data in RDBMS is stored in database objects called tables. The table is a collection of related data entries and it consists of columns and rows.
Remember, a table is the most common and simplest form of data storage in a relational database.

RDBMS Concepts

A Relational Database management System (RDBMS) is a database management system based on relational model introduced by E.F Codd. In relational model, data is represented in terms of tuples (rows).

Relational Database Definitions

•         Entity: Object, Concept or event (subject)

•         Attribute: a Characteristic of an entity

•         Row or Record: the specific characteristics of one entity

•         Table: a collection of records

•         Database: a collection of tables

A relational database is one whose data are split up into tables, sometimes called relations.

Database (DB)

Here are some different definitions and concepts related to Database and Database Management System.

Database

Database is an organized collection of fact. In other word we can say that it is collection of information arranged and presented to serve and assigned purpose.
An example of Database is a dictionary, where word arranged alphabetically. Another example is telephone directory.

Database

A database is an organized collection of data whose content must be quickly and easily Accessed

Managed

Updated

Database definition:

A Database is a collection of related data organized in a way that data can be easily accessed, managed and updated. Any piece of information can be a data, for example name of your school. Database is actually a place where related piece of information is stored and various operations can be performed on it.

Database:
A database is a collection of stored operational data used by various applications and/or users by some particular enterprise or by a set of outside authorized applications and authorized users.

•         Database

–        Stores all organizational data in central location

–        Eliminates redundant data to reduce possibility of inconsistent data

                         

What is a database?

A database is a collection of data which can be used:

•       alone, or

•       Combined / related to other data to provide answers to the user’s question.

Database Management System (DBMS)

A DBMS is software that allows creation, definition and manipulation of database. DBMS is actually a tool used to perform any kind of operation on data in database. It maintains data consistency in case of multiple users. Here are some examples of popular dbms, MySql, Oracle, Sybase, Microsoft Access and IBM DB2 etc.

Components of Database System:

The database system can be divided into four components.

Users: Users may be of various types such as DB administrator, System developer and End users.

Database application: Database application may be Personal, Departmental, Enterprise and Internal.

DBMS: Software that Allows users to define; create and manages database access, Ex: MySql, Oracle etc.

Database: Collection of logical data.

Database Management System

Database Management System is About Managing and structuring the collections of data held on computers. A database consists of an organized collection of data for one or more uses, typically in digital form. Database involves the type of their contents.
E.g.:- bibliographic, document - text, statistical.


Database Management System (DBMS)

A Database Management System (DBMS) is a software program that enables the creation and management of databases. Generally, these databases will be more complex than the text file/spreadsheet.

Some of the more popular relational database management systems include:

Microsoft Access, File maker, Microsoft SQL Server, MySQL, and Oracle.