Be prepared to write sql to create a table including an

Question

Review Exam
Be able to explain, define or identify the following terms:

 

Entity                               Table                                 RDBMS

Attribute                           Relationship                       Constraint

DDL                                  Tuple                                Row   

Chen Notation                    Crow's Foot Notation         N:M Relationship

Cursor                               Derived Attributes             Cardinality                 
NULL                                 Mandatory Participation      Data redundancy
Data                                  Field                                ER Model

File                                    Data Model                       SQL

DML                                  Candidate Key                   Normalization

Primary Key                       Foreign Key                       Composite Key

1:1 Relationships               1:M Relationships               Recursive Relationship

aggregate functions           Group by                           Identifier

Join                                  Trigger                              Relation

Surrogate Key                   Super Key                         Index

View                                 Referential Integrity  

1^st Normal Form                2^nd Normal Form                3^rd Normal Form

Partial Dependency

Components of a database system
Codd's 8 rules to be a relation
Recognize code for Stored Proc, Function, and Trigger
Modification Anomaly (Three kinds)
Data vs. Information
Unstructured Data vs. Structured Data

Be prepared to write SQL to create a table including an Identity.
Be prepared to write SQL to create a foreign key constraint.
Be prepared to write SQL to solve a problem.
Be prepared to draw a ERD using crowfoot notation.