Given unnormalized magazine subscription table with data below: SubsNo SubsName MagCode MagName SubscriptionStartDate PubCode PubContact 102...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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. 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.
Expert Answer:
Answer rating: 100% (QA)
SOLUTION quetion a primary key and foreign keys and functional dependancies are shown each table str... View the full answer
Related Book For
Financial Reporting And Analysis
ISBN: 9781260247848
8th Edition
Authors: Lawrence Revsine, Daniel Collins, Bruce Johnson, Fred Mittelstaedt, Leonard Soffer
Posted Date:
Students also viewed these 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...
-
Suppose that Canada produces two goods: lumber and fish. It has 18 million workers, each of whom can cut 10 feet of lumber or catch 20 fish each day. a. What is the maximum amount of lumber Canada...
-
Consider a put option on a non-dividend-paying stock when the stock price is $40, the strike price is $42, the risk-free rate of interest is 2%, the volatility is 25% per annum, and the time to...
-
Suppose that the supply curve for the labor to a firm is given by L = 100w and the marginal expense of labor curve is given by MEL = L/50 Where w is the market wage. Suppose also that the firm's...
-
What procedures are required in vouching dividend payments?
-
The adjusted trial balance for Bere Company is given in E4-16. Instructions Prepare the closing entries for the temporary accounts at August 31.
-
An administrator needs to run the Check Disk utility on a Windows workstation, but they need to ensure that no other processes read from or write to that drive while the utility is running. What...
-
Amherst Networking Systems adjusts and closes its books and then prepares financial statements monthly. Amherst uses the perpetual inventory system and all sales on credit have terms of n/30. The...
-
What opportunities and threats will marketers encounter as a result of climate change? What can the marketer do to capitalize on the opportunities and work with the threats?
-
The director of the child protection agency is pleased with the report, but would also like to see it in graphic format. What chart type(s) would be inappropriate? Why? What chart type(s) would be...
-
What subclass of report would you design for the sales manager of a car dealership whose job it is to review vehicle sales each week and year to date? What data elements should be included Problems...
-
The sales manager has asked you to develop an automated chart to show the companys annual sales by quarter for the past five years. The manager considers bar charts boring and wants to use a pie...
-
You have volunteered to work on the Web site of your local library. The library plans to develop an online catalog of books that can be reserved by library patrons from their home computers via the...
-
Scope definition is the first phase of the chapters methodology, and it is either the first phase or part of the first phase of most methodologies. What triggers the scope phase, which stakeholders...
-
A thermistor used for temperature measurement has 3 = 3140K and the resistance at 270C is 105002. If the resistance of the thermistor is measured as 233002, deter- mine the temperature measured by...
-
Michelles trust is subject to 3.8% surtax on the lesser of the trusts net investment income or the excess of the trusts adjusted gross income over the $12,400 threshold (the highest trust tax rate)....
-
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...
-
A diesel engine of mass \(300 \mathrm{~kg}\) and operating speed \(1800 \mathrm{rpm}\) is found to have a rotating unbalance of \(1 \mathrm{~kg}-\mathrm{m}\). It is to be installed on the floor of an...
-
A sensitive electronic system, of mass \(30 \mathrm{~kg}\), is supported by a spring-damper system on the floor of a building that is subject to a harmonic motion in the frequency range \(10...
-
A machine of mass \(1150 \mathrm{~kg}\) is mounted on springs. A piston of mass \(m=25 \mathrm{~kg}\) moves up and down in the machine at a speed of \(600 \mathrm{rpm}\) with a stroke of \(350...
Study smarter with the SolutionInn App