Flashcards in ch5 Deck (21):
Users have critical roles in database application development.
Another name for a column is a record.
Relational databases represent relationships through the use of formal keys.
The name of the field and the data type and width are an example of metadata
A database application consists of forms, reports, and database programs.
A DBMS is software that helps manage the operating system.
A DBMS is a collection of tables, relationships and metadata.
A DBMS can be used to add a new column to a table.
A database form translates the inputted change into a SQL query in order for the database to process it.
A physical representation of a database is called a data model.
A data model describes the data and relationships that will be stored in the database.
“PartNumber” would be a good identifier for a part entity in a database application
Each entity should have one unique identifier
In a 1:M type of relationship, the foreign key is stored on the “1” side.
Normalization is a process that helps ensure that the tables from the database design process are well structured.
Database integrity problems produce inconsistent answers, but this is easily corrected.
Normal forms have duplicated data removed.
In order to transform a data model into a database design, one must first represent each entity with a table.
DBMS is just a model of how users view the business world.
Oracle and DB2 are examples of multi-featured personal DBMS.