Question: 1) What is the main difference between the logical and physical design of a database? 2) What are the three types of relationships? Be able

1) What is the main difference between the logical and physical design of a database? 2) What are the three types of relationships? Be able to identify properties of each and be able to identify each type of relationship. 3) Be able to read Crows Feet in an ERD. What are the different Crow Feet options (Cardinality)? Be able to write Business Rules from an ERD, as well as draw out Business rules. 4) Be able to use ERDPlus to create, export and insert Entity Relationship Diagrams. 5) How does one resolve a many-to-many relationship so that it works in the physical database? Be able to resolve such an issue. 6) What are the four types of entities and what does each mean? 7) What are the three types of anomalies that Normalization seeks to resolve? Explain each. 8) Explain the first three forms of normalization and the goal of each. Can you normalize a table? 9) What it the difference between a functional dependency and a transient dependency? 10) Review the lecture notes and be able to identify the different ways of creating tables in Access. 11) What things need to be considered when selecting a RDMS? (Ch. 6) 12) What are the common data type formats in Access and their descriptions? 13) What is the standard SQL command and format for creating a table in Access
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
