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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!