Below is the solution of the QuestionNo.2 from the Normalization Exercises that I posted earlier.
QuestionNo2: Following are the attributes required to be stored by an organization during transactions. You are required to identify how many tables are required to store these attribute in Normalized Form.
Quantity Sold,
Date/Time of Sale,
Salesperson,
Product Name,
Product Category,
Product SubCategory,
Manufacturer Name,
Store Location,
Phone Number,
City Name,
State,
Population
You can assume any example data for this exercise.
Sales Detail
| ProductID | StoreID | SalesPersonID | QuantitySold | Date_Timeof Sale |
| Product id | ProductName | ProductCategoryID | ProductSub CategoryID | ManufacturerID |
| ProductCategory ID | ProductCategoryName | ParentCategory ID |
| SalesPersonID | SalespersonName | StoreID |
| ManufacturerID | ManufacturerName | ManufacturerAddress |
| StoreID | CityID | StoreLocation | PhoneNumber |
| CityID | CityName | StateID | Population |
| StateID | StateName |
0 comments:
Post a Comment