Question: Consider a Laptop sales database. The database is having information on selling of various models of laptops. Consider the following relation: Laptop_SALE(Laptop_Model, Sales_Person, Amount_of_Discount, Percentage_of_Commission,,

Consider a Laptop sales database. The database is having information on selling of various models of laptops. Consider the following relation:

Laptop_SALE(Laptop_Model, Sales_Person, Amount_of_Discount, Percentage_of_Commission,, Sold_Date)

A Laptop might be sold by different salesperson, henceforth the primary key will be a combination of Laptop_Model and Sales_Person

FDs based on primary key: Sales_Person -> Percentage_of_Commission Sold_Date -> Amount_of_Discount

Answer the following : i. Identify whether the relation is 1NF, 2NF or 3NF. ii. Why or why not? Justify. iii. In what way u could progressively normalize it totally?

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!

\f\f\fChapter 2 Service Strategy Learning Objectives After completing this chapter, you should be able to: 1. Formulate a strategic service vision. 2. Describe how a service competes using the three...

Consider the following relational database that stores information about computer hardware products (keys are underlined, field types are omitted): Product (maker, model, type) PC (model, speed, ram,...

CHA P TER 9 Understanding Software: A Primer for Managers 1. INTRODUCTION L E A R N I N G O B J E C T I V E S 1. Recognize the importance of software and its implications for the rm and strategic...

Consider the Mobile sales database. The database is maintaining complete information on selling of various brands of mobiles. There are two major relations namely Mobile_Purchase and...

The Excel file Store and Regional Sales Database provides sales data for computers and peripherals showing the store identification number, sales region, item number, item description, unit price,...

The excel file store and regional sales database provides sales data for computers and peripherals showing the store identification number, sales region, item number, item description, unit price,...

1 . The Excel file Store and Regional Sales Database provides sales data for computers and peripherals showing the store identification number, sales region, item number, item description, unit...

The Excel file Store and Regional Sales Database provides sales data for computers and peripherals showing the store identification number, sales region, item number, item description, unit price,...

2) In EXCEL display a descriptive statistic on Units Sold by using Data Analysis Add-in , then answer the following questions: a. What is the Kurtosis? How to interpret it? b. What is the Skewness?...

A. the total number of units sold. B. the total number of units sold in the South region. C. the total number of units sold in December. please be sure to include this exact excel sheet which shows...

Consider a random variable X with the cumulative distribution function (cdf) given by Fx (x) = 0 2 X if x

Repeat parts (b)(e) of Exercise 7.17 for samples of size 5. (There are six possible samples.) b. For samples of size 2, construct a table similar to Table 7.2. (There are 15 possible samples of size...

( A ) [ 2 0 points ] Your firm is based in southern Ireland ( and thereby operates in euro, not pounds ) and is considering an investment in the United States. The project involves selling widgets:...

Can you please help me with the following question: Baitem Inc. had budgeted for $4,760,000 of manufacturing overhead. During the year, the company had worked 125,000 labours, but had budgeted for...

1 What can we tell from the above analysis in Table 3.3 and the average DPPs per customer? (Consider in particular the differences in DPP between the four orders shown, and between the three...

1 Review the categories in Figure 3.1 and compile your own list of the way in which these categories can be influenced (made better or worse) in an organisation.

3 What are the opportunities and threats facing suppliers as a result of the likely changes to Globals quality of service priorities? This case study contains information on how Globals expectations...