Database Design using the E-R Model

Question 1

Choosing a data model

Answer 1

Second Phase

Question 2

characterize full the data need of the prospective database user

Answer 2

Initial Phase

Question 3

Deciding on the database schema

Answer 3

Logical Design

Question 4

Deciding on the physical layout of the database

Answer 4

Physical Design

Question 5

Moving from an abstract model to the implementation of the database

Answer 5

Final Phase

Question 6

collection of entities and relationship

Answer 6

Entity Relationship Model

Question 7

formalize what design are bad and test for them

Answer 7

Normalization Theory

Question 8

developed for database design allowing for specification of an enterprise schema that represents the overall logical structure of a database.

Answer 8

Entity Relationship Data Model

Question 9

A picture showing the information created. stored and used by a business system

Answer 9

Entity Relation Diagram (ERD)

Question 10

Information captured about an entity

Answer 10

Attributes

Question 11

Names are noun

Answer 11

Attributes