Mis-Dbms

Only available on StudyMode
  • Download(s) : 248
  • Published : March 17, 2013
Open Document
Text Preview
Thursday, February 28, 2013

Objective
.

Database and a database management system (DBMS) Architecture of a DBMS Define the three traditional database models Describe the relational model and relations. SQL Commands. Describe the steps in database design. Define ERM and E-R diagrams

Define the hierarchical levels of normalization and understand the rationale for normalizing the relations.

Management Information System 2

Hemant Kumar Jain : maluhe27@hotmail.com

Thursday, February 28, 2013

Database & DBMS Definition:A Database is a collection of interrelated data , typically describing the activities of one or more related objects /organizations and is used for managing large bodies of information which include efficient storage of information and retrieval of the stored information.

Management Information System 4

Hemant Kumar Jain : maluhe27@hotmail.com

Thursday, February 28, 2013

Database & DBMS
A Database Management System (DBMS) is a collection of programs that enables users to create and maintain a database or contains a set of interrelated data with set of programs to access the data. DBMS provides an environment that is both convenient and efficient to use. The DBMS is hence a general-purpose software system that facilitates the processes of defining, constructing, and manipulating databases for various applications.

Management Information System 5

Hemant Kumar Jain : maluhe27@hotmail.com

Thursday, February 28, 2013

Tables
Table
Field 1 Field 2 Field 3 ROW ... .... ...

COLUMN

Management Information System 6

Thursday, February 28, 2013

Attributes
A named property or characteristic of an entity that is of interest to an organization Student_Id Patient_Id FirstName FirstName MiddleName MiddleName LastName LastName DateOfBirth DateOfBirth FathersName Address

Attributes

Address City City Country Country PhoneNo PhoneNo email_ID email_ID Height

Student Patient

AdmnDate Weight
Course_Id Blood Group Fees Pressure Blood ... Eyesight

Management Information System 7

Hemant Kumar Jain : maluhe27@hotmail.com

Thursday, February 28, 2013

Attributes (Columns), Tuples (Rows), Relations (Tables)
Attribute/Column (Fields) Table

STUDENT _TABLE Student_Id AdmnDate FirstName LastName Address City 53 Panchdeep Apts, Sahajpal Vikas Puri 154, Kavri Apts Gupta Vikas Puri, 05 BN CRPF CAMP, Kesri Mahavir Nagar A-101, Shankar Chopra Garden, Vikas Puri

S_110
S_111 S_112 S_113

01-Dec-10
08-Dec-10 09-Dec-10 03-Dec-10

Aparna
Sanjeevani Tushar Mahak

New Delhi
New Delhi New Delhi New Delhi

Tuples/ Records

Primary Key

Management Information System 8

Hemant Kumar Jain : maluhe27@hotmail.com

Thursday, February 28, 2013

Database Architecture

The American National Standards Institute/ Standards Planning and Requirements Committee (ANSI/SPARC) has established a three-level architecture for a DBMS: 1. Internal, 2. Conceptual 3. External

Management Information System 9

Hemant Kumar Jain : maluhe27@hotmail.com

14.9

Database Architecture
Internal level The internal level determines where data is actually stored on the storage devices. This level deals with low-level access methods and how bytes are transferred to and from storage devices. In other words, the internal level interacts directly with the hardware. Conceptual level The conceptual level defines the logical view of the data. The data model is defined on this level, and the main functions of the DBMS, such as queries, are also on this level. The DBMS changes the internal view of data to the external view that users need to see. The conceptual level is an intermediary and frees users from dealing with the internal level. External level The external level interacts directly with the user (end users or application programs). It changes the data coming from the conceptual level to a format and view that is familiar to the users. Management Information System...
tracking img