You will need to maintain a list of all fashion products carried. For each store, you...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You will need to maintain a list of all fashion products carried. For each store, you will need to maintain the inventory of all products. For each product, you track a list price, but for now, you require the price to be the same across all stores. You dream of someday opening stores across Canada and know the price will vary across Canada, but for now, you want to focus on the minimum viable product and build the necessary scalability into the database. You do anticipate opening more stores throughout Alberta. You also have an old customer database where you track customers. Their purchases are tracked via invoices, including the quantity, list price, percentage discount, and price paid for each item. At the time of sale, the list price matches the list price for the product, but the product list price can change; whereas the invoice list price remains the same. Unfortunately, this database has been corrupted and you need to start from the beginning. Product are grouped into product lines (formal and casual), although you anticipate adding wedding clothes in the future. Products are further classified into different categories (for example shirt, shoes, belts etc.). Each product may belong to only one category. Additionally, products are associated with specific tags to help identify sales opportunities. For instance, shirts may be associated with the tags like "spring", "3 summer", "fall", "winter", "wool", "synthetice", etc. Additional Detail While not all products are available at all stores, there is a large overlap in the products. In addition to the invoice percentage discount for each item, there may be an overall discount applied to a complete invoice. For each customer, an address and list of phone numbers are tracked. Previously you only allowed customers to enter a home and mobile number, but you found many customers are giving an alternate mobile number and you have decided the new database should support as many phone numbers as customers choose to give. At least one phone number is required for easy lookup. For small quick purchases, without a discount, there is a "guest" customer that is associated with the purchase. This customer is associated with the phone number "000-000-0000". Stores are identified by a short name (e.g. "Stephen Avenue" is short for and a full name of "Calgary - Stephen Avenue", or "Mountain" for "Canmore - Mountain"). It is important to understand what products are sold at which stores. Although somewhat redundant based on the list price and percentage discount, the actual sell price and total invoice amount are both stored in the database fo easy querying later. Products are sold either by item, or size or weight. You can't be sure that you won't allow additional methods (such as length for measuring rope) in the future, so you have decided to create a table to allow for new methods to b added. Assume there is no sales tax on any of the items. ASSIGNMENT INSTRUCTIONS Create an Entity Relationship Diagram (ERD) for your fashion shop situation. Include the cardinality of relationships and make sure to define the primary (PK) keys (s), foreign (FK) key(s), composite (CK) keys and which attributes are involved in each relationship. All bridging tables should make use of a composite key. Many-to-Many relationships may not be used, and your final product should be in 3rd You will need to maintain a list of all fashion products carried. For each store, you will need to maintain the inventory of all products. For each product, you track a list price, but for now, you require the price to be the same across all stores. You dream of someday opening stores across Canada and know the price will vary across Canada, but for now, you want to focus on the minimum viable product and build the necessary scalability into the database. You do anticipate opening more stores throughout Alberta. You also have an old customer database where you track customers. Their purchases are tracked via invoices, including the quantity, list price, percentage discount, and price paid for each item. At the time of sale, the list price matches the list price for the product, but the product list price can change; whereas the invoice list price remains the same. Unfortunately, this database has been corrupted and you need to start from the beginning. Product are grouped into product lines (formal and casual), although you anticipate adding wedding clothes in the future. Products are further classified into different categories (for example shirt, shoes, belts etc.). Each product may belong to only one category. Additionally, products are associated with specific tags to help identify sales opportunities. For instance, shirts may be associated with the tags like "spring", "3 summer", "fall", "winter", "wool", "synthetice", etc. Additional Detail While not all products are available at all stores, there is a large overlap in the products. In addition to the invoice percentage discount for each item, there may be an overall discount applied to a complete invoice. For each customer, an address and list of phone numbers are tracked. Previously you only allowed customers to enter a home and mobile number, but you found many customers are giving an alternate mobile number and you have decided the new database should support as many phone numbers as customers choose to give. At least one phone number is required for easy lookup. For small quick purchases, without a discount, there is a "guest" customer that is associated with the purchase. This customer is associated with the phone number "000-000-0000". Stores are identified by a short name (e.g. "Stephen Avenue" is short for and a full name of "Calgary - Stephen Avenue", or "Mountain" for "Canmore - Mountain"). It is important to understand what products are sold at which stores. Although somewhat redundant based on the list price and percentage discount, the actual sell price and total invoice amount are both stored in the database fo easy querying later. Products are sold either by item, or size or weight. You can't be sure that you won't allow additional methods (such as length for measuring rope) in the future, so you have decided to create a table to allow for new methods to b added. Assume there is no sales tax on any of the items. ASSIGNMENT INSTRUCTIONS Create an Entity Relationship Diagram (ERD) for your fashion shop situation. Include the cardinality of relationships and make sure to define the primary (PK) keys (s), foreign (FK) key(s), composite (CK) keys and which attributes are involved in each relationship. All bridging tables should make use of a composite key. Many-to-Many relationships may not be used, and your final product should be in 3rd
Expert Answer:
Answer rating: 100% (QA)
Im unable to directly create an Entity Relationship Diagram ERD because I cant generate images However I can describe how to create an ERD for your fa... View the full answer
Related Book For
Financial Reporting Financial Statement Analysis and Valuation a strategic perspective
ISBN: 978-1337614689
9th edition
Authors: James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Posted Date:
Students also viewed these programming questions
-
Read the following notes or watch any videos and follow along. At the top be sure to title it "1.1 Purpose of Accounting" and write the name "Nicholas Court'" These are YOUR notes. Make sure to take...
-
List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...
-
You will review and analyze the mission statement, case information, and financial statements of Canada Hardware Inc. You will use the information from your review to develop a SWOT analysis with the...
-
2. C. b. d. e. a. A proposed public project would produce the following pattern of individual benefits and costs. Revise only the cost shares of individuals C and E to meet the Pareto Criterion. (7...
-
Walter owns a whole-life insurance policy worth $52,000 that directs the insurance company to pay the beneficiary $250,000 on Walter's death. Walter pays the annual premiums and has the power to...
-
A poker hand (5 cards) is drawn from an ordinary deck of 52 cards. Find the probability of each event, showing your reasoning carefully. a. The first four cards are the four aces. b. Any four cards...
-
Management Assertions and Audit Objectives. The following are management assertions (1-7), and audit objectives applied to the audit of accounts payable (ah). Management assertion 1 Existence 2...
-
Carolyn is senior vice president of finance and chief actuary for Rock Solid Insurance Company (RSIC). Lonnie is double-majoring in finance and mathematics at State University. Lonnie applied for an...
-
Find the value(s) of k that makes the function continuous over the given Interval. *2+7x+6 F(x ) x #-6 x + 6 k, x=-6 km Additional Materials LO Reading 11. [-/3 Points] DETAILS
-
a. A 6% coupon bond paying interest annually has a modified duration of 10 years, sells for $800, and is priced at a yield to maturity of 8%. If the YTM increases to 9%, what is the predicted change...
-
4. How much is Yell worth assuming that it is said debt-free to Apafouse Hicks and that the market risk premium is 6%? What is the maximum bid that you would recommend
-
Who isDr. Deming's? What is their view on cost-cutting? Is it directed by management or due to an edict that the budget must be met?
-
Comparing Three Depreciation Methods Dexter Industries purchased packaging equipment on January 8 for $796,600. The equipment was expected to have a useful life of four years, or 8,400 operating...
-
what ways does moral absolutism assert that certain actions are intrinsically right or wrong, and what challenges does this perspective face in a world of diverse cultural and ethical beliefs ?
-
Feather Friends, Inc., distributes a high-quality wooden birdhouse that sells for $80 per unit. Variable expenses are $40.00 per unit, and fixed expenses total $180,000 per year. Its operating...
-
Your first task is daunting. You have been selected as representatives of a new country, just given its independence. Your job is to help draft the country's new Constitution. Prior to achieving...
-
the Find all complex given eacarons 8 i=0 (i) 43 + (ii) 2 x + i = 0 P
-
The registrar of a college with a population of N = 4,000 full-time students is asked by the president to conduct a survey to measure satisfaction with the quality of life on campus. The following...
-
Texas Instruments primarily develops and manufactures semiconductors for use in technology-based products for various industries. The manufacturing process is capital-intensive and subject to...
-
Given the following information, compute December 31, 2017, projected benefit obligation (PBO) and fair market value (FMV) of plan assets for Lee Company. What amount of asset or liability will be...
-
Sun Microsystems, Inc., develops, manufactures, and sells computers for network systems. Exhibit 5.20 presents selected financial data for Sun Microsystems for each of the five years ending June 30,...
-
If equity investors contribute $1,000,000 and want a .30 return at time 4, how much do they require at time 4?
-
a. Assume the value of a firm's equity is $1,000 and $800 of .10 debt is substituted for equity. The corporate tax rate is .35. What is the new value of the equity? What total wealth do the...
-
Assume a $800 investment returns $1,000 at time 1 (a .25 return). What is the IRR on $100 of equity if $700 of .08 debt is used as well as equity?
Study smarter with the SolutionInn App