Relational_Database_Management_System_No.pdf - ADARSH...

This preview shows page 1 - 5 out of 209 pages.

ADARSH INSTITUTE OF TECHNOLOGY (POLY), VITA RELATIONAL DATABASE MANAGEMENT SYSTEM… CO/CM/IF 3G VIREN SIR 07/07/2016 ITS REGARDING ALL CHAPTER NOTES FOR RDBMS WITH COMPLETE SYLLABUS.IF SOME POINTS ARE MISSING THAT NOT MUCH IMPORTANT FOR THEORY.THE NOTES ARE PREPAARE USING COMPLETE REFERENCE BOOKS, INTERNET PDF FILES AND MSBTE ODEL ANSWER PAPER….THANKING YOU….
Viren Sir--8928135013 Page 1 CHAPTER 1. INTRODUCTION Data:- Data are raw facts and figures that on their own have no meaning These can be any alphanumeric characters i.e. text, numbers, symbols Example Yes, Yes, No, Yes, No, Yes, No, Yes 42, 63, 96, 74, 56, 86 None of the above data sets have any meaning until they are given a CONTEXT and PROCESSED into a useable form Data into Information To achieve its aims the organisation will need to process data into information. Data needs to be turned into meaningful information and presented in its most useful format Data must be processed in a context in order to give it meaning Information:- Data that has been processed within a context to give it meaning OR Data that has been processed into a form that gives it meaning Example In the next 3 examples explain how the data could be processed to give it meaning What information can then be derived from the data?
Viren Sir--8928135013 Page 2 Knowledge:- Knowledge is the understanding of rules needed to interpret information Using the previous examples: A Marketing Manager could use this information to decide whether or not to raise or lower price y
Viren Sir--8928135013 Page 3 1.1 An Introduction to database. Definition Of Database :- A database is a collection of data, typically describing the activities of one or more related organizations. For example, a university database might contain information about the following: Entities such as students, faculty, courses, and classrooms. Relationships between entities, such as students' enrollment in courses, faculty teaching courses, and the use of rooms for courses Definition Of DBMS :-A database-management system (DBMS) is a collection of interrelated data and a set of programs to access those data Goal Of DBMS :- The primary goal of a DBMS is to provide a way to store and retrieve database information that is both convenient and efficient . Database System Applications Databases are widely used. Here are some representative applications: Banking : For customer information, accounts, and loans, and banking transactions. Airlines : For reservations and schedule information. Universitie s : For student information, course registrations, and grades. • Credit card transactions : For purchases on credit cards and generation of monthly statements. • Telecommunication : For keeping records of calls made, generating monthly bills, maintaining balances on prepaid calling cards, and storing information about the communication networks. • Finance : For storing information about holdings, sales, and purchases of financial instruments such as stocks and bonds. • Sales : For customer, product, and purchase information. • Manufacturing :

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture