22319 Lecture Notes - Database, Data Redundancy, Data Integrity
Document Summary
1. 1 concept of data, database, dbms, advantages of dbms over file processing system, application of database. 1. 3 data abstraction: levels, instance and schema, data independence- logical and physical independence. 1. 5 data modeling: record based logical model-relational, network, hierarchical. 1. 6 data modeling using e-r model, strong entity set, weak entity set, types of attributes, e-r diagrams: define dbms: The database management system can be defined as collection of interrelated data & set of program / tools to operate on it: name of various dbms & rdbms software: Domain: domain can be defined as set of permitted value for a particular attribute. 1. 4 list 12 rules of fully functional rdbms: 04 marks. The whole data should represent to the user in the form table. The complete data should available or accessible to the user without any ambiguity. The ambiguity should can avoid only by a strong combination of table name, primary key column name.