Expect problems and eat them for breakfast.
--Your friends at LectureNotes

Note for Database Management System - DBMS By Prakruthi V

  • Database Management System - DBMS
  • Note
  • Vellore Institute of Technology Amravati - VIT-AP
  • Information Technology Engineering
  • Uploaded 2 months ago
Prakruthi V
Prakruthi V
0 User(s)
Download PDFOrder Printed Copy

Share it with your friends

Leave your Comments

Text from page-1


Text from page-2

• • • • • • • • • Data base System Applications Data base System VS file System View of Data – Data Abstraction Instances and Schemas Data Models – The ER Model – Relational Model – Other Models Database Languages - DDL – DML Database Access for applications Programs Data base Users and Administrator Transaction Management •v Data base System Structure • Storage Manager • The Query Processor •History of Data base Systems • Data base design and ER diagrams • Beyond ER Design • Entities, Attributes and Entity sets • Relationships and Relationship sets • Additional features of ER Model • Conceptual Design with the ER Model • Conceptual Design for Large enterprises.

Text from page-3

Data is raw, unprocessed information. In and of itself it may not mean much. Examples: Data: A person's age, a person's gender, or the color of a car. Individually, it means not much. Information, on the other hand, is processed data that has meaning. Information: If a program takes the above data and processes it, now the results take meaning. Example: A 25 year old man likes to drive a red car.

Text from page-4

Data:• Facts, statistics used for reference or analysis. • Numbers, characters, symbols, images etc., which can be processed by a computer. • Data must be interpreted, by a human or machine, to derive meaning • “Data is a representation of information” * • Latin ‘datum’ meaning “that which is given” • Data plural, datum singular Information:• Knowledge derived from study, experience (by the senses), or instruction. • Communication of intelligence. • “Information is any kind of knowledge that is exchangeable amongst people, about things, facts, concepts, etc., in some context.” * • “Information is interpreted data” *

Lecture Notes