Question: normalization III - Normalization - The table shown below lists information about software and the companies that developed these software. The Softwareld is unique for
normalization

III - Normalization - The table shown below lists information about software and the companies that developed these software. The Softwareld is unique for each Software. (30 points) SOFTWAREID (SOFTWARENAME, COMPANY) COMPANY (COMPANYCITY, COMPANYMANAGER, COMPANYPHONE#) Software ID SoftwareName Company Company CompanyManager CompanyPhone# City POS5112 POS Soft Expert Beirut Adam Hammoud 01876258 BS9090 Bank System Smart Service Tyre Sara Hashem 07752896 PH8243 Pharmacy SoftExpert Beirut Adam Hammoud 01876258 CP2390 Computer Parts Smart Service Tyre Sara Hashem 07752896 The table is susceptible to anomalies. Provide examples of insertion, deletion, and update anomalies * Your answer Describe and illustrate the process of normalizing the table into 3NF Your
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
