SQL MATERIAL (1)

SQL MATERIAL (1) - Suresh 1 Data: Data is the most...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Suresh Data : Data is the most important component in any work that we do; Data means collection of information or collection of raw facts. Ex: 1. Text files 2. Facts 3. Figures (photos) 4. Audios 5. Videos etc. .. Database: collection of related data. DBMS :( Database Management System) Data Base Management System is the management system or maintenance system on databases. (Or) It is a suit of software program for creating, maintaining & manipulating the data in database. (Or) It allows the users to insert the data, to retrieve the data, to modify the data and to delete the data. Properties: 1. Create 2. Insert 3. Update 4. Delete 5. Select (query) 6. Low level security etc. .. Ex: FoxPro, ims (information management system) The first databases of kind existed in the form of files. A file is nothing but collection of records. A Record is nothing but collection of information or data. But the file system was not very efficient .it was crippled by slow data search speed. It includes the following Drawbacks. 1.Security 2.Data Redundancy 3.Data Integrity 4.Concurrency Control 5.Slow in Process 6. File system: in a dbms database, data must be stored in the form of files only Note: basic property of file system is independent and individual, means each and every file is unique AND relation is not possible between data files 7. Low level security, No Login name No Password. RDBMS (Relational Database Management System): 1
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Suresh Data must be stored in the form of tables only Relation between Tables is possible Table : It is collection of columns and rows, X axis directions are rows and Y axis directions are columns Relation : Creating internal dependencies between Database Tables Ex of RDBMS: 1. Sqlserver 2. Oracle 3. Db2 (Database 2000, IBM) 4. Mysql (open source) 5. ms-access 6. Postgresql (open source) 7. Sybase 8. Tera data Etc. .... Terminology: 1. Table -- Entity 2. Column (field) -- Attribute 3. Row (record) -- Tupple 4. Duplicate data (Repeated data) – Data Redundancy Metadata : Data about data, it describes characteristics of data Ex: Description of a table Syn: sp_help <TN> Ex: sp_help EMP Note: <TN> stands for Table name Data models: 1. Hierarchy data model 2. Network data model 3. Relational data model Note: Currently all RDBMS Databases following RELATIONAL DATA MODEL Adv of Relational Data model: Relation Perfect solution for duplicate data and null values Normalization Normalization : It is a process of eliminating duplicate data from the database. EF CODD RULES: 2
Background image of page 2
Suresh Sqlserver 2005: 1. It is RDBMS database 2. It is a product of Microsoft 3. It is case insensitive 4. It is platform dependant-- it is compatible for windows OS 5. User friendly History: Introduced in 1994 Sqlserver 4.0 Sqlserver 5.0 Sqlserver 6.0 Sqlserver 6.5 Sqlserver 7.0 Sqlserver 8.0(2000) Sqlserver 9.0(2005) Sqlserver 10.0(2008) Editions (flavors): 1. Enterprise edition 2. Standard edition 3. Developer edition 4. Mobile edition
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 79

SQL MATERIAL (1) - Suresh 1 Data: Data is the most...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online