click below
click below
Normal Size Small Size show me how
INFS247Chapter7
terms and whatnot
| Question | Answer |
|---|---|
| 1st Database Development Activity | Project Planning and Initiation |
| 2nd Development Activity | Conceptual Design (Requirement Collection and ER Modeling) |
| 3rd Development Activity | Logical Design (Relational Modeling) |
| 4th Development Activity | Implementation (Via DBMS) |
| 5th Development Activity | Use (via DBMS or Indirect) and Maintenance |
| Entity | Person, place, object, event, or concept |
| Attribute | Property or characteristic of an entity |
| Key Attribute | An attribute that uniquely identifies individual instances of an entity |
| Relationship | An association among the instances of entity types |
| Cardinality Constraints | The number of instances of one entity that can or must be associated with each instance of another entity. Consists of: - Minimum Cardinality (Participation) - optional - mandatory - Maximum Cardinality - One - Many |
| Primary Key | - Uniquely identifies a row in a relational table - Equivalent to the Key attribute in the ER model |
| Foreign Key | - Used to implement relationships (one-to-one, one-to-many, many-to-many) in relational model - Depicted by the Referential Integrity Constraint: a line with an arrow pointing from the foreign key to its source. |
| Components of a DBMS | - Data definition - Data manipulation - Application generation - Data administration |
| Data definition component | allows user to create tables and relationships |
| Data manipulation | allows users to create, read, update, and delete information in a database. |
| Application generation | Allows users to create various interfaces to databases. Users can define report and form formats. |
| Data administration | Allows DBA (Data Base Administrator) to maintain technical aspects of database systems (such as performance, security, etc.) |