Reference no: EM132648572

Assignment: Software skills: Database conceptualisation and design.

Business skills: How databases support functional area(s)

Select any one functional area in a business organisation. Think about the data involved in the processes. Based on your selection, use an Entity Relationship Diagram (ERD) to depict the data model of the functional area. The materials covered in class (on databases and general MIS) may be useful in helping you select a functional area for analysis. Please be sure to select something that is manageable. Please also have at least 4 entities (2 points per entity) in your ERD with appropriate attributes. Please do not use the ERD examples covered in class because we're supposed to think. There is no need to have all possible attributes. But please have relevant/suitable ones for each entity. Some attributes can be pointless, depending on the design of your database. And we don't want to have unnecessary ones. Please also include an explanation of the functional area/process you are modeling, and detailed justification for the entities and relationships, as this will determine how you want your database to work in support of the function you selected (2 points). You can refer to Chapter 1 for functional area information systems (FAIS) and how they function within an organisation.

Your ERD must be constructed using Visio (or equivalent). Paste the ERD in a word document as a picture for submission. Seattle's virtual desktop should have Visio installed. If you really have issues accessing Visio, you can conceptualise it and use the computer in the lab. This will minimise the amount of time you need using the software itself. Please do not draw it manually, as this is an MIS class after all. We are expected to use technology tools to solve problems.