Question: Please answer a , b and c 3. (50 points) Normalization Consider the following ComputerSales relation (table) hold details of sales related data for various

Please answer a , b and c

Please answer a , b and c 3. (50 points) Normalization Consider

3. (50 points) Normalization Consider the following ComputerSales relation (table) hold details of sales related data for various computer models in a retail chain's database. ComputerSales (ModelNumber, ModelName, StoreNumber, StoreName, StoreManager, StoreCity, NumberSold, GrossSales, DCNumber, ManufacturerName, DCAddress) Suppose that the following functional dependencies are present in the ComputerSales relation. FD1: ModelNumber -> ModelName, ManufacturerName FD2: StoreNumber -> StoreName, StoreManager, StoreCity FDS ModelNumber, StoreNumber NumberSold, GrossSales FD4: StoreCity > DCNumber, DCAddress Determine the primary key of the ComputerSales relation. Decompose CustomerSales into 2NF, and then into 3NF relations. Clearly identify the primary key for each of the newly formed relations. Using the 3NF relations, construct an ER diagram. Clearly state any assumptions made a) b) c)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

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!

please answer a, b and c 3. (50 points) Normalization Consider the following ComputerSales relation (table) hold details of sales related data for various computer models in a retail chain's...

3. (50 points) Normalization Consider the following ComputerSales relation (table) hold details of sales related data for various computer models in a retail chain's database. ComputerSales...

There are two problems due this week (each worth 35 points) as follows. Problem 1.6 (page 20) In comprehensive paragraphs, answerrequirements a to e. You will have 5 paragraphs total of four to five...

Hi! I have completed the exam, but am looking for someone to provide the answer key! Name: PENN ID: _________________________ ACCOUNTING 101 - 620, EXAM #1 Spring Semester, 2010 Instructions: 1. 2....

Give Correct ANSWERS Human-Computer Interaction (a) If you had been one of the original inventors of the WIMP interface, and engineers on the technical team had been sceptical about the advantages...

Can you please answer this questions below QUESTION 1 The key to any successful report is clarity, ____, completeness, and correctness. a. actuality b. longevity c. brevity 2 points QUESTION 2 A is a...

Needing ANSWERS ASAP! Starting at pg 34 - Labeled Graded Project 06155200: Graded Project Instructions & Worksheets 1 Lesson 1: Business, Accounting, and You PROJECT GOAL The goal of this graded...

uantitative Analysis BA 452 Homework 3 Questions Homework 3 covers the theory and applications in Lessons I-6 and I-7. This document has four parts: Objectives of doing your homework. Assignment of...

1. Which of the following represents the core drives of the information age? A. Data, Information, Business Intelligence, Knowledge. B. Fact, Data, Intelligence, Experience. C. Fact, Intelligence,...

Consider implementing the natural logarithm function ln(t) for floating-point numbers using the McLaurin series: ln (i) List all special behaviours the natural logarithm function should have in...

The volcanic eruptions with the greatest death tolls since 1900 are described in Table 2. a. Identify the individuals. b. Identify the variables. c. Identify the observations for each variable. d. Of...

Gentle Care Products Company is considering an investment in one of two new product lines. The investment required for either product line is $500,000. The net cash flows associated with each product...

A portfolio is: Multiple Choice a single risky security. any new issue of stock. a group of assets held by an investor. any security that is equally as risky as the overal market. an imestment in a...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

LO4 Analyze workplace monitoring, employer investigations, and other steps taken to ensure a safe and productive workplace.

3. The decline in union representation in the workforce means that employees have a more direct relationship with their employer. Lacking the protection and advocacy provided by a labor union puts...

2. Privacy issues are in the forefront as websites, marketers, and now employers begin to collect data on every move we make. While many people appreciate customized services, they dont approve of...