Harrisburg Area Community College Database Design Methodology Essay

Part 1

17.5 Describe the purpose of integrity constraints and identify the main types of integrity constraints on a logical data model. explain each constraint and provide an example of each constraint other than the one in the text. (500 word minimum)

Connolly, T., & Begg, C. (2014). Database Systems: A Practical Approach to Design, Implementation, and Management (6th ed.). Pearson Learning Solutions. https://online.vitalsource.com/books/9781269875356

Part 2

Functional analysis:
Part —- > Price, Cost, Supplier, Street, City, State, Zip, Telephone
Supplier —- > Street, City, State, Zip, Telephone
Part —- > Price, Cost, Supplier
Table:
Parts (Part, Price, Cost, Supplier, Street, City, State, Zip, Telephone)

1.Is the above table in 2NF? 6%
2.Using the table and field names in the above table explain your answer in plain English. (100 word minimum)