Basic definitions of dbms
?
1 like?489 views
This is a note I made 2 years ago for myself. Here you can see the definition of Data, Information, Database, Meta data, DBMS, Record, File, Crow's Foot notation, Table, Data, Logical Data Type, Domain, Primary key, keys, Foreign key, Super key, Candidate key, Secondary key, Relational Set Operations with example of: Union, Intersection, Difference, Product.
Basic definitions of dbms
- 2. Record: A logically connected set of one or more fields, which describes a person, place or anything else. File: A collection of related records. Constraints: It is a restriction placed on a data. Constraints are important because they helps to ensure, data integrity. Constraints are normally represented in a form of rules. Ex- A student's CGPA must be above 6.0.