sql database Develop a logical data model based on the following
requirements:
• Refinement of the conceptual model - including a refined
Enhanced Entity-Relationship (EER) diagram.
• Derivation of relations from the refined conceptual model.
• Validation of logical model using normalization to BCNF.
• Validation of logical model against corresponding user
transactions.
• Definition of integrity constraints including:
– Primary key constraints.
– Referential Integrity (foreign key) constraints.
– Entity integrity (NULL and default value) constraints.
– Alternate key constraints.
– General constraints if any.
Model:
- Sql Database Develop A Logical Data Model Based On The Following Requirements Refinement Of The Conceptual Model In 1 (158.74 KiB) Viewed 29 times
Develop a business contact interaction tracking system. Businesses must carefully record informa- tion about interaction with important business contacts. This system must include the following: Descriptive data for contacts, such as name, salutation, job title, employer, manager, subor- dinates, secretary, addresses (home, office, mailing), phone numbers (home, office, cellular, fax, secretary), email addresses, and personal comments. • Data for events of interaction, such as phone calls, email, and postal mail. For each interac- tion event, record the date and comments. Your system must also enable searches, such as • The interaction events associated with a particular contact (for example, John Smith). • List all the interaction events made during a particular time period (for example, between July 1, 2021 and December 31, 2021). • List the information for all contacts available in a particular company (for example, Company ABC). • List the total number of phone calls made during a particular time period (for example, between January 1, 2022 and January 31, 2022).