Develop an eer model for the given problem description

Assignment Help Computer Engineering

Reference no: EM131926544

Assignment

PROBLEM DESCRIPTION:

House2Home Franchise Application Database System

House2Home is a retail chain that operates throughout Australia and some foreign countries. Their main business revenue is generated from selling computers, home electronics and furniture. Originally, the central operational team manages all of the House2Home retail shops. However, due to the business changes, the company increasingly franchise out their departments to different franchisee teams. So far, the franchise application process has been handled using a paper based system. With the continuous growth of the retail chain, House2Home wants to automate the application and selection process in Australia. For the automated web-based system to work, they need an underlying database that can cater for the relevant data. They have asked for a solution that will work best to support their business process, which is described below.

The company has many stores spread across Australia. To keep track of each store, the company wants to store information such as unique store identification number, store address (including street & number, suburb, postcode and state), weekdays operating hours and weekend operating hours.

TASKS:

You are required to develop an EER model for the above problem description. The EER should contain all necessary information such as entities, attributes, primary keys, relationships (including specialization/generalization if any), cardinalities, and participation (including (min, max)). All specialization/generalization and union type must be represented accordingly, instead being treated as simple association relationships. Any assumptions should also be stated clearly. If assumptions are made, it is important to make sure that the assumptions reflect possible real practice for a particular industry and do not contradict with the problem description above. Assignment should be typed, not written/drawn by hand. Use any software to draw figures in your assignment.

Attachment:- PROBLEM-DESCRIPTION.rar

Reference no: EM131926544

Questions Cloud

Estimate the firms net new financing for firm x : Sales in 2017 are expected to grow at a rate of 12.5% with respect to the values of 2016. Assume the company pays out 65% of its net income.

How much does the second annuity pay each year : You are comparing two annuities with equal present values. The applicable discount rate is 7.25 percent. One annuity pays $2,500 on the first day of each year.

Describe human anatomy and physiology : Use relevant vocabulary, including anatomical positions, to describe human anatomy and physiology and the role of homeostasis and metabolism

How much money will you make into the arbitrage buying : You are looking at option prices on calls and puts and noticed that Biogen Idec (BIIB) is currently selling at $319.55. You look up the price of a call.

Develop an eer model for the given problem description : House2Home Franchise Application Database System. You are required to develop an EER model for the above problem description.

What is the inventory turnover ratio of this firm : What is the current ratio of this firm? What is the quick ratio of this firm? What is the inventory turnover ratio of this firm?

Determine a fair level of expected return : Your forecasting model projects an expected return of 17.25% for Stock A and an expected return of 33.75% for Stock B. Using the information in questions.

Relationship and the differences between lmna : Explain the relationship and the differences between LMNA, LMNC, and progerin.

What are the implications of the three theories : What are the implications of the three theories for financial managers regarding the optimal capital structure?

User Account

All Pages