22319 Lecture Notes - Database, Data Redundancy, Data Integrity

14 views16 pages
Department
Course
Professor

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.

Get access

Grade+20% off
$8 USD/m$10 USD/m
Billed $96 USD annually
Grade+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
40 Verified Answers
Class+
$8 USD/m
Billed $96 USD annually
Class+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
30 Verified Answers

Related Documents

Related Questions