Course Notes Essay

Candidate Key – A primary key that consist of more then one attributes.
Natural Keys - A key that naturally occurs in the attributes of an entity, such as a student ID or a course name.
Surrogate Key - A key that naturally occurs in the attributes of an entity, such as a student ID or a course name.
Composite Key - A key that naturally occurs in the attributes of an entity, such as a student ID or a course name.
A Report - Output of summary material from data.
Work Shadowing - The act of following someone, as he or she performs the duties of his or her job, to see what the job entails and what actions he or she typically performs during the workday Data integrity - Refers to the accuracy and quality of the data.
Normalization – The process of decomposing relations with anomalies to produce smaller, well- structured relations.
Referential Integrity Referential integrity refers to enforcing the constraints of primary key–foreign key relationships.
Specifically, you cannot insert a value into a child table unless it exists in the parent table. You update the foreign key column of a child table if it would change it to a value that is not in the parent table. You cannot delete a record from the parent table if it has related records in a child table, unless you first delete the records in the child table.
Physical design The design of the database within a particular
DBMS. The physical design takes account of file systems and disk locations as well as DBMS-specific data types.
Logical design The design of a database without regard to the physical implementation of the database
Null A null is an unknown value. It is not the same as a 0 or an empty string. As an unknown, it cannot be evaluated with = !. Data manipulation language - A data manipulation language (DML) is a family of syntax elements similar to a computer programming language used for inserting, deleting and updating data in a database. Performing read-only queries of data is sometimes also considered a component of DML.

ROLE In a database
, a set of permissions related to a particular use of a database.
Schema Schema has several related meanings. On the one hand, it is the structure of a database and its tables; on the other, it is the structure of ownership of objects. “dbo,” for instance, is the default schema for database objects. Lastly, it can be an
XML document that describes the structure of another

Show More