Professor Materials Week 2 Flashcards
What are the advantages of databases?
program/data independence
reduced data duplication
data consistency
data sharing
faster application development
standards enforcement
better data quality
improved accessibility
less maintenance
What are the disadvantages of databases?
Database adminstrator and other specialized personnel needed
Installation and management costs
Conversion costs
need for explicit backup and recovery
organizational conflict
What are the three types of database relationships?
One-to-one (rare)
one-to-many
many-to-many
What is a weak entity?
An entity that cannot exist in a database i.e. an order that has no customer.
What is a mandatory relationship?
A relationship that must exist, i.e. an order must have a customer.
What is a composite entity?
E
Entities that exist to represent the relationship between two or more entitites.
What are the two development approaches?
top-down (Start at general and drill down)
bottom-up (start with details and work up)
What is the database development lifecycle?
- Create a data model (E-R model)
- Transpose data into relationships
- Normalize relations
- Implement the relational schema within a DBMS
- Define forms, queries, reports, menus
- Populate data
- Maintenance
What is the UoD?
Universe of Discourse, a short description of the subset or mdoel of reality that we are interested in implementing
What is data modeling?
The process of determining what items are of importance to the users, rules that users need to be enforced and creating a model to capture that
What is the schema?
Design for the database , including its tables, relationships, domains and constraints.
Syntax: RELATION_NAME(primary_key(underlined), attribute1, attribute2)