IT Business case

IT503: Principles of Information Technology

Assignment Unit 5

Unit 5 Assignment: Business Case Practice After completing the unit reading, complete the following Unit 5 Practice Activity before starting your assignment. Unit 5 Learning Journal To help you prepare for this assignment, please complete this week’s Learning Journal activity. In this activity you will review the types of relationships used in entity-relationship diagrams. This will help you to correctly identify the relationships between the entities. 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 (YouTube search term: relational database model). Submitting your work: Submit your Assignment to the appropriate Dropbox. In your file name, be sure to include the unit number and your last name.

IT503: Principles of Information Technology

Assignment Unit 5

Assignment Criteria Points possible Points earned by student

Student uses an appropriate format for an Business Case

0-10

Student explains the business intelligence 0-10 Student explains data management 0-10 Student explains how database management can be used to create business intelligence.

0-20

Student describes five data entities 0-20 Student creates an entity-relationship diagram 0-15 Student creates a relational database model 0-15 Column Totals 100 Less deduction taken for spelling, grammar and APA errors

New total after deductions