Answered You can hire a professional tutor to get the answer.
QUESTION
\ Special Event Permit* 2017 - 01 - 27 Complete* Special Event| Free Speech Stand With Imr* 2017 - 01 - 25 2017 - 01 - 29 Downtown* Westlake Pal 875
Database System
1) Using the SpecialEvenPermit table (see image below),
Business rules:
- Each event is sponsored by one or more organizations.
- Each organization can sponsor one or more events.
- Each event has zero or one categories.
- Each category has zero or one sub-categories.
- Each event takes place in zero or more neighborhoods.
- Each neighborhood can host zero or more events.
- Each event takes place in zero or more parks.
- Each park can host zero or more events.
- You may discover or infer additional business rules as you decompose the table.
Hints:
- ApplicationNumber is an intelligent key. The 2nd and 3rd digits are the year of the event and the 3rd and 4th characters are the month of the event. Is it suitable as a primary key? What might happen to the value if an event's date is changed?
- You may need to use surrogate primary keys for some of the decomposed entities.
2) Using the 3NF relationship diagram for SpecialEventPermit created in problem #2, draw a complete ERD diagram for the normalized tables. Be sure to label the primary keys and foreign keys, and use the correct cardinalities for your crow's foot connectors.
