Implementing a database management system

Assignment Help Database Management System

Reference no: EM13754203

Assignment Instructions: Business Intelligence

You have been hired as a consultant for a small retail company that sells widgets online. The company is interested in learning how to use their data to improve their business. They have asked you to write a business case (search term business case template) to explain the justification for implementing a database management system to improve business intelligence within the company.

Within your business case, begin by explaining business intelligence. Then explain data management and how a database management system can facilitate business intelligence. You should also explain the benefits that the company will experience with the system.

Next, consider the design of the system. Begin by describing the data entities, attributes and keys. For instance, a data entity may be Customer. Attributes of customer may include name and address. The key may be a uniquely assigned customer number. You should have at least five data entities in your database. Create an entity-relationship diagram showing the relationship between the entities (YouTube search term: entity relationship diagram tutorial). Create a relational database model to describe the data.

Reference no: EM13754203

Questions Cloud

Difference between system and application software : You have identified several companies that specialize in software for small businesses. Please write a "request for proposal" (RFP). To write an RFP, you need to identify the needs of the company. Begin by explaining the difference between system ..

In a troubled debt restructuring : In a troubled debt restructuring in which the debt is continued with modified terms, a gain should be recognized at the date of restructure, but no interest expense should be recognized over the remaining life of the debt,

New sausage system with an installed cost : Kolby’s Korndogs is looking at a new sausage system with an installed cost of $765,000. This cost will be depreciated straight-line to zero over the project’s six-year life, at the end of which the sausage system can be scrapped for $100,000.

Result from applying the lower of cost or market rule : West Distribution Co. has determined its December 31, 2007 inventory on a FIFO basis at $360,000. West records losses that result from applying the lower of cost or market rule. At December 31, 2007, the loss that West should recognize is

Implementing a database management system : They have asked you to write a business case (search term business case template) to explain the justification for implementing a database management system to improve business intelligence within the company

Better care clinic-breakeven analysis : Fairbanks Memorial Hospital, an acute care hospital with 300 beds and 160 staff physicians, is one of 75 hospitals owned and operated by Health Services of America, a for-profit, publicly owned company. Although there are two other acute care hospita..

Project component how to calculate net working capital : Recalling from our second class session and the first project component how to calculate net working capital. Any investment (increase) in net working capital is considered a cash outflow, while any use (decrease) of net working capital is considered..

Preparing domain and group structures : The company's IT department has asked you to prioritize recommendations for Windows Server® roles. High-priority roles may be installed immediately

Process of updating its networks : Your company is in the process of updating its networks. In preparation for the upgrade, your CEO has requested that you write a white paper (search term: White paper template) explaining the various telecommunication technologies

User Account

All Pages