Analysis Analyse and identity from the case scenario: 1. II. III. all key stakeholders (entities) and...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Analysis Analyse and identity from the case scenario: 1. II. III. all key stakeholders (entities) and their attributes. all business rules that define the relationship(s) between them. all business constraints/validation lists that the data model may include. Requirement: You must use ONLY the prescribed set notations in your analysis please refer to the appendix for the guideline and examples. You must include at least eight key stakeholders (goes not include tables of constraints) in your data model. Assuming you have identified most of the three parts listed above correctly but with some errors, you can achieve a pass mark or up to a maximum mark equivalent of a Credit. To earn a Distinction, you must identify two additional key stakeholders and relevant attributes. You must establish relevance for including them. All relevant attributes and relationships must be identified correctly. Any M.M relationships must also be translated and resolved correctly (in both the business rules and shown in your ER-D) To eam a High Distinction, you must include another two key stakeholders and relevant attributes. Again, you must establish relevance for including them. All relevant relationships must also be identified. All M:M relationships must also be resolved correctly. Note: Any deviation from the prescribed convention will result in loss of marks 02. Design Based on your completed analysis (01), design an E-R diagram to represent a data model of the case scenario. Components to consider and include: Entities and attributes Primary keys Foreign keys Cardinalities Consistency and completeness of the diagram using only one of the suggested tools. Recommended took: https://app.diagrams.net (draw.io); alternate tool: Microsoft Visio Requirement: Use Crow's foot notation ONLY. Please refer to the appendix for an example. The guideline will be discussed in class and tutorial sessions. It is important you attend all sessions. Some relevant discussions will be recorded and made available for your reference as well. Note: Any deviation from the prescribed norm will result in loss of marks Any additional entities/attributes/relationships you have identified must be correctly represented in the ER-D to gain the higher marks. Where possible, you want to avoid criss-crossing the line connectors. All line connectors between entities should be correctly attached to the entities, identifying also the common keys shared between them. The criteria weights are as follow: 30 marks | Appropriate table structures are created. 20 marks | Proper use of constraints. 20 marks | Normalised database design (with the intuitive methodology). 20 marks | Clear and concise conventions and notations. Case scenario A new local coffee shop, called Muffin & Java, wants to keep track of its front inventory and customer orders. You and your team were asked to consider the front logistics of the business. Then, design a new data solution that is capable of tracking customer orders made online or directly in the store. MUFFIN & JAVA STORE TCH On the outset, your team can immediately identify a few key entities: Muffin_Types, Coffee Types, Inventory and Customer Sales. Your team will need to identify and fill in the related attributes as well in the analysis stage. For example, Muffin Types (muffin_ID, muffin_name, price) The database needs to be capable of tracking data about the product availability, the staff, the sales, sales items, and other related information. Your team must evaluate and propose at least another four entities to track (not mentioned in the scenario) to ensure the smooth running of the coffee store. Muffin & Java staff comprises of a crew of seven and they are all paid the hourly wage. Some available positions include the manager, barista, baker, kitchen helper, and general crew member. The employee data that should be tracked include staff ID, first name and last name, date of birth, email, contact number, position, and starting date. If any customers want to order via the website or mobile app, they must complete an online registration. The customer information stored should include the name, e-mail, contact number, password, security question, date of registration (default is the current date), account status (default is ACTIVE), and a customer ID, which is uniquely generated and assigned when the account is first created. The customer is also given the option to store payment information for faster checkout. The customer can also opt for paperless invoice for online orders. Whenever a customer completed an order, a sales order is created. When the order is paid, an invoice is generated and issued. If the customer has opted for paperless, the invoice will be emailed to the customer. . 10 marks | Proper use of primary and foreign keys Appendix. A Guide for recording your work for submission Q1. An example on how to approach and prepare the report of your analysis Note: Clearly outline your analysis using set notations only-other format will NOT be accepted in this assignment. Main Stakeholders (Entities) and their related attributes -- Minimally, you should identify 8 entities; use the following template: Entity_name(comma-separated list of attributes) Add {name_of_constraint) to a field to indicate the table of constraint/validation list. Use the naming convention prescribed in class. For example, Movie (mediaID, title, releasedDate, category, rating, copiesAvailable, genre) MovieCopy feataloqueNo, mediaID, formati: tbl format), rentalRate, state, availability) Role (roleID, mediain, actarID, character, description} Actor (actorID, firstName, lastName, dob, country! Business Rules (define the relationships between the entities) -- Minimally, you must identify 7 pairs of business rules: Each pair of business rules describe one relationship Any M:M relationships must be translated into 1:M's for a relational database E.g. Movie: MovieCopy (1:M) A movie has one or more copies A movie copy is associated with one and only one movie E.g. this is how a M:M relationship should be documented Movie:Actor (M:M) A movie is made up of one or many performing actors An actor can also act in one or many movies { } Movie:Role (1:M) A movie has one or more character roles A character role is associated with one movie Actor Role (1:M) An actor can play in one or more roles A role is associated with one actor Business Constraints (limits the types of values) Consider only field constraint - one or more values that limit a field. E.g. tbl Format (SD, HD, 3D, 2K) format description. SD HD 3D 2K Standard definition title High definition 3-Dimensions Q2. An example how to approach and prepare your report of your ER-D E.g. 2xHigh Definitions PK medialD genre Movie releasedDate category rating copiesAvailable PK rollD FK medialD FK actor D Role character description PK FK MovieCopy catalogueNo medialD format rentalRate state availability Actor PK actor D firstName lastName dob country Analysis Analyse and identity from the case scenario: 1. II. III. all key stakeholders (entities) and their attributes. all business rules that define the relationship(s) between them. all business constraints/validation lists that the data model may include. Requirement: You must use ONLY the prescribed set notations in your analysis please refer to the appendix for the guideline and examples. You must include at least eight key stakeholders (goes not include tables of constraints) in your data model. Assuming you have identified most of the three parts listed above correctly but with some errors, you can achieve a pass mark or up to a maximum mark equivalent of a Credit. To earn a Distinction, you must identify two additional key stakeholders and relevant attributes. You must establish relevance for including them. All relevant attributes and relationships must be identified correctly. Any M.M relationships must also be translated and resolved correctly (in both the business rules and shown in your ER-D) To eam a High Distinction, you must include another two key stakeholders and relevant attributes. Again, you must establish relevance for including them. All relevant relationships must also be identified. All M:M relationships must also be resolved correctly. Note: Any deviation from the prescribed convention will result in loss of marks 02. Design Based on your completed analysis (01), design an E-R diagram to represent a data model of the case scenario. Components to consider and include: Entities and attributes Primary keys Foreign keys Cardinalities Consistency and completeness of the diagram using only one of the suggested tools. Recommended took: https://app.diagrams.net (draw.io); alternate tool: Microsoft Visio Requirement: Use Crow's foot notation ONLY. Please refer to the appendix for an example. The guideline will be discussed in class and tutorial sessions. It is important you attend all sessions. Some relevant discussions will be recorded and made available for your reference as well. Note: Any deviation from the prescribed norm will result in loss of marks Any additional entities/attributes/relationships you have identified must be correctly represented in the ER-D to gain the higher marks. Where possible, you want to avoid criss-crossing the line connectors. All line connectors between entities should be correctly attached to the entities, identifying also the common keys shared between them. The criteria weights are as follow: 30 marks | Appropriate table structures are created. 20 marks | Proper use of constraints. 20 marks | Normalised database design (with the intuitive methodology). 20 marks | Clear and concise conventions and notations. Case scenario A new local coffee shop, called Muffin & Java, wants to keep track of its front inventory and customer orders. You and your team were asked to consider the front logistics of the business. Then, design a new data solution that is capable of tracking customer orders made online or directly in the store. MUFFIN & JAVA STORE TCH On the outset, your team can immediately identify a few key entities: Muffin_Types, Coffee Types, Inventory and Customer Sales. Your team will need to identify and fill in the related attributes as well in the analysis stage. For example, Muffin Types (muffin_ID, muffin_name, price) The database needs to be capable of tracking data about the product availability, the staff, the sales, sales items, and other related information. Your team must evaluate and propose at least another four entities to track (not mentioned in the scenario) to ensure the smooth running of the coffee store. Muffin & Java staff comprises of a crew of seven and they are all paid the hourly wage. Some available positions include the manager, barista, baker, kitchen helper, and general crew member. The employee data that should be tracked include staff ID, first name and last name, date of birth, email, contact number, position, and starting date. If any customers want to order via the website or mobile app, they must complete an online registration. The customer information stored should include the name, e-mail, contact number, password, security question, date of registration (default is the current date), account status (default is ACTIVE), and a customer ID, which is uniquely generated and assigned when the account is first created. The customer is also given the option to store payment information for faster checkout. The customer can also opt for paperless invoice for online orders. Whenever a customer completed an order, a sales order is created. When the order is paid, an invoice is generated and issued. If the customer has opted for paperless, the invoice will be emailed to the customer. . 10 marks | Proper use of primary and foreign keys Appendix. A Guide for recording your work for submission Q1. An example on how to approach and prepare the report of your analysis Note: Clearly outline your analysis using set notations only-other format will NOT be accepted in this assignment. Main Stakeholders (Entities) and their related attributes -- Minimally, you should identify 8 entities; use the following template: Entity_name(comma-separated list of attributes) Add {name_of_constraint) to a field to indicate the table of constraint/validation list. Use the naming convention prescribed in class. For example, Movie (mediaID, title, releasedDate, category, rating, copiesAvailable, genre) MovieCopy feataloqueNo, mediaID, formati: tbl format), rentalRate, state, availability) Role (roleID, mediain, actarID, character, description} Actor (actorID, firstName, lastName, dob, country! Business Rules (define the relationships between the entities) -- Minimally, you must identify 7 pairs of business rules: Each pair of business rules describe one relationship Any M:M relationships must be translated into 1:M's for a relational database E.g. Movie: MovieCopy (1:M) A movie has one or more copies A movie copy is associated with one and only one movie E.g. this is how a M:M relationship should be documented Movie:Actor (M:M) A movie is made up of one or many performing actors An actor can also act in one or many movies { } Movie:Role (1:M) A movie has one or more character roles A character role is associated with one movie Actor Role (1:M) An actor can play in one or more roles A role is associated with one actor Business Constraints (limits the types of values) Consider only field constraint - one or more values that limit a field. E.g. tbl Format (SD, HD, 3D, 2K) format description. SD HD 3D 2K Standard definition title High definition 3-Dimensions Q2. An example how to approach and prepare your report of your ER-D E.g. 2xHigh Definitions PK medialD genre Movie releasedDate category rating copiesAvailable PK rollD FK medialD FK actor D Role character description PK FK MovieCopy catalogueNo medialD format rentalRate state availability Actor PK actor D firstName lastName dob country
Expert Answer:
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these databases questions
-
The brightness of the Sun as observed from the Moon can be used to design a solar panel array at a colony on the Moon. The Moon is 1 . 5 \ times 1 0 1 1 m from the Sun. The array can convert energy...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
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...
-
1. Evaluate the term "health" and the historical perspective on health promotion. 2. Examine health promotion and illness prevention teaching based on teaching principles, varied teaching learning...
-
Two 32-inch pumps are combined in parallel to deliver water at 20C through 1500 ft of horizontal pipe. If f = 0.025, what pipe diameter will ensure a flow rate of 35,000 gal/min at 1170 rpm?
-
Let A be a 4 5 matrix. If a1, a2, a4 are linearly independent and a3 = a1 + 2a2 a5 = 2a1 - a2 + 3a4 determine the reduced row echelon form of A.
-
State the major changes which have occurred in auditing techniques during the last 160 years. Explain briefly how changes in technology have impacted on the changes in auditing techniques.
-
One of the major problems that Bohn faced was that only about 40 percent of the jobs listed for scheduled maintenance shutdowns were ever performed. During an informal conversation with Ken Viet,...
-
Half a liter of gas in an air conditioner is initially at a temperature of 25 degrees Celsius and 2.0 atm of pressure. The volume of the gas is rapidly expanded to 2 L and the pressure of the gas...
-
Who do you think the CEO should appoint as CIO? Why? The Suarez Effect Pat Talley stood and watched, with grudging admiration, as Carmelita Suarez worked the room. Sharp, charming, and armed with a...
-
milar ound
-
How did you apply active listening to seek information and confirm your understating as you interacted with a child or group of children?
-
Why, in fact, does Marxism breed regimes which are totalitarian in nature? How does multiculturalism at play?
-
3. Consider a two period problem where a consumer has preferences over consumption in the two periods given by: log c + Blog c'. She has no initial assets and has income y in the first period y' in...
-
Does the monopoly power wielded by professional sports leagues hurt the fans, players, citizens, local economies, or the sport? What solutions could be used ?
-
Levinn's utility function is expressed as the following: U= C1 C2 0.3 where C1 is his first period consumption and C2 is his second period consumption. His income in the first period is $2500 and...
-
100 g of which of the following contains the greatest number of atoms A. Ar(g) B. Cl2(g) C. P4(g) D. S8(g)
-
The graph of the sequence whose general term is an = n - 1 is which of the following? [8.1] A. B. TITTT 3-2-1 23.45 2.3.4
-
Jim (age 50) and Martha (age 49) are married with three dependent children. They file a joint return for 2012. Their income from salaries totals $50,000, and they received $10,000 in taxable...
-
Fisafolia Corporation has gross income from operations of $220,000 and operating expenses of $160,000 for 2012. The corporation also has $20,000 in dividends from publicly traded domestic...
-
Cedar Corporation has an S corporation election in effect. During the 2012 calendar tax year, the corporation had ordinary taxable income of $200,000, and on January 15, 2012, the corporation paid...
-
The power spent in suction and exhaust strokes are known as: (a) Brake horse power (b) Indicated horse power (c) Pumping power (d) None of the above
-
The difference of total power produced and pumping power is known as: (a) Brake horse power (b) Indicated horse power (c) Net indicated horse power (d) None of the above
-
In an Otto cycle, air at 1 bar and \(300 \mathrm{~K}\) is compressed isentropically until the pressure rises to 16 bar. The heat is added at constant volume until the pressure rises to 30 bar....
Study smarter with the SolutionInn App