Question: Given unnormalized magazine subscription table with data below: SubsNo SubsName MagCode MagName SubscriptionStartDate PubCode PubContact 102 Alysha DIS Disney 012332323 XYZ 014568585 ABC 012332323

Given unnormalized magazine subscription table with data below: SubsNo SubsName MagCode MagName SubscriptionStartDate PubCode PubContact 102 Alysha DIS Disney 012332323 XYZ 014568585 ABC 012332323 104 105 103 Ryan Sarah Adrian Times Week RB Readers Book TW LND Landscape NAT Nautical Sc TW Times Week RB Readers Book 15/1/2020 1/1/2020 1/1/2020 1/1/2020 1/2/2020 2/1/2020 2/1/2020 EE Exploratory 1/3/2020 TW Times Week 15/2/2020 Subs-Subscriber, Mag-Magazine, Pub-Publisher] and some functional dependencies below: subsNo --> subsName magCode --> magName, pubCode, pubContact ABC 000 05669887 MOM 019232356 XYZ 014568585 ABC 012332323 MOM 019232356 XYZ 014568585 (a) Add additional functional dependencies which are applicable to the table; and determine primary/composite key of the table. (b) Normalize the table from First Normal Form (1NF) to Second Normal Form (2NF) until Third Normal Form. Given unnormalized magazine subscription table with data below: SubsNo SubsName MagCode MagName SubscriptionStartDate PubCode PubContact 102 Alysha DIS Disney 012332323 XYZ 014568585 ABC 012332323 104 105 103 Ryan Sarah Adrian Times Week RB Readers Book TW LND Landscape NAT Nautical Sc TW Times Week RB Readers Book 15/1/2020 1/1/2020 1/1/2020 1/1/2020 1/2/2020 2/1/2020 2/1/2020 EE Exploratory 1/3/2020 TW Times Week 15/2/2020 Subs-Subscriber, Mag-Magazine, Pub-Publisher] and some functional dependencies below: subsNo --> subsName magCode --> magName, pubCode, pubContact ABC 000 05669887 MOM 019232356 XYZ 014568585 ABC 012332323 MOM 019232356 XYZ 014568585 (a) Add additional functional dependencies which are applicable to the table; and determine primary/composite key of the table. (b) Normalize the table from First Normal Form (1NF) to Second Normal Form (2NF) until Third Normal Form. Given unnormalized magazine subscription table with data below: SubsNo SubsName MagCode MagName SubscriptionStartDate PubCode PubContact 102 Alysha DIS Disney 012332323 XYZ 014568585 ABC 012332323 104 105 103 Ryan Sarah Adrian Times Week RB Readers Book TW LND Landscape NAT Nautical Sc TW Times Week RB Readers Book 15/1/2020 1/1/2020 1/1/2020 1/1/2020 1/2/2020 2/1/2020 2/1/2020 EE Exploratory 1/3/2020 TW Times Week 15/2/2020 Subs-Subscriber, Mag-Magazine, Pub-Publisher] and some functional dependencies below: subsNo --> subsName magCode --> magName, pubCode, pubContact ABC 000 05669887 MOM 019232356 XYZ 014568585 ABC 012332323 MOM 019232356 XYZ 014568585 (a) Add additional functional dependencies which are applicable to the table; and determine primary/composite key of the table. (b) Normalize the table from First Normal Form (1NF) to Second Normal Form (2NF) until Third Normal Form.

Step by Step Solution

★★★★★

3.35 Rating (155 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

SOLUTION quetion a primary key and foreign keys and functional dependancies are shown each table str... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

For each table, identify the primary keys and the foreign key(s). If a table does not have a foreign key, write None in the space provided. Employee Table: -Primary key_____ -Foreign Key_____...

Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...

A state imposes a sales tax of 6 percent. The state's counties are permitted to levy an additional tax of 2 percent. The state administers the tax for the counties, forwarding the proceeds to the...

AICPA Case Development Program Case No. 96-08: New Horizons, Inc. 1 HISTORY NEW HORIZONS, INC. David M. Dennis, Professor University of South Florida, Tampa, Florida Steven S. Oscher, Managing...

Please make Critical appraisal for the methodology, appropriateness of research design and other critique for the research below. thank you International Journal of Academe and Industry Research...

Read the Accounting for Software Development Activities Case Study (link below). After reading the case study, answer the questions provided. While Ms. Larson is confident with regard to the U.S....

Middle Road Media: A Codification Research Case on the Accounting for Software Development Activities ABSTRACT: The accounting for software development costs is a complex issue within the financial...

The Keels Agency (TKA) is a small advertising agency in Portland, Oregon that helps clients get the biggest return on their advertising dollars. TKA specializes in working with companies that are...

1) What are the advantages and disadvantages of Distributed Database Systems? 2) Partitioning is very key in distributed Databases. It is one of the techniques used in making optimization decisions...

2.21 Can someone please explain how she came up with all the numbers on the table? how did she compute all the minutes and how she came up with 23.80 or 27.80 and so on on with the table? I need to...

Save the file as "Your Last Name, First Initial BUS320 Wk3 Activity" After completing the activity, upload the Excel spreadsheet to the WK3 Assignment Upload folder NIKE, INC. BALANCE SHEET ($...

An analysis of the transactions made by Blossom & Co., a certified public accounting firm, for the month of August is shown below. The expenses were $550 for rent, $3,800 for salaries and wages, and...

A company plans to configure a vessel's journey in Dynamics 365 Supply Chain Management by using the landed cost functionality. The company needs to track the details of each step of the journey...

10 Which of the following is NOT a disadvantage of virtual integration in supply chains? 1 point Often variations in the IT capabilities and existing level of infrastructure across supply chain...

ACTIVITY 3: PREPARE ME Below are the Income Statement and Balance Sheet of Hobert Supply and Services. Using these data, prepare the company's Statement of Changes in Equity. Herbert Supply and...

A data professional works on a financial audit. During the verification process, they keep in mind the big picture view of confirming that the company's financial statements comply with accounting...

Need it right now ..help! 4 points On January 15, 2016, Jaymes Company received a two-month, 4%, $7.000 note from Peter Long for the settlement of his open account. The entry by Jaymes Company on...

Hotel Majestic is interested in estimating fixed and variable costs so that the company can make more accurate projections of costs and profit. The hotel is in a resort area that is particularly busy...

The following information pertains P15-8 to the pension plan of Beatty Business Group: Note that the information in Columns (2) and (3) are as of the beginning of the year, whereas the information in...

In November and December 20X1, Gee Company, a newly organized magazine publisher, received $36,000 for 1,000 three-year subscriptions at $12 per year, starting with the January 20X2 issue of the...

Cishek Corporation sold $100 million of gift cards in 20X1. The gift cards may be used to purchase goods from Cishek in the future. The gift cards never expire, and Cishek expects that none of the...

The cost of goods sold for Canadian Tire for a recent year was $7,326 million. The balance sheet showed the following current account balances (in millions): Determine the amount of cash payments for...

On the basis of the details of the following bonds payable and related discount accounts, indicate the items to be reported in the Financing section of the statement of cash flows, assuming no gain...

Union Financial Services Ltd. purchased the following held-for-trading securities during 2014, its first year of operations: There were no sales of securities during 2014 or 2015. The market price...