Submit a Word document with the answers to the following questions. Review Relational Databases Essential Training and Quick Start Guide to SQL Who was E.F. Codd?What are the Pros and Cons of a table

by


Submit a Word document with the answers to the following questions.

Review Relational Databases Essential Training and Quick Start Guide to SQL

  1. Who was E.F. Codd?
  2. What are the Pros and Cons of a table structure?
  3. What is an integrity error?
  4. What does CRUD stand for?
  5. What is the purpose of an entity relationship diagram?
  6. What is Crow’s feet notation?
  7. Create an ERD using an ERD tool. (www.lucidchart.com or (www.quickdatabasediagrams.com). Provide a copy of the diagram.
  8. What constraint type is a primary key?
  9. What is a Check constraint?
  10. What is a foreign key? Give an example.