Part 1 Data Management 10 Points Software Skills Database Co ✓ Solved

Part 1 Data Management 10 Pointssoftware Skills Database Conceptual

Part 1 Data Management (10 points) 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. 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. You can try Gliffy in Google Docs or on the browser. There are others too. Grading rubric The grading rubric is given below. 10% of the points are given to truly exceptional work. Criteria Outstanding Acceptable Troll ERD entity points Very appropriate and relevant entity. Very appropriate and accurate attributes assigned, including the primary key, and highly accurate relationships Somewhat appropriate entity. Somewhat appropriate and accurate attributes assigned, including the primary key, and/or somewhat accurate relationships. There are some attributes that are not clear or inappropriate, or there are missing attributes. For example, “marketing” is not likely to be an appropriate attribute. “Marketing” is also not a clearly defined entity. “Marketing department” is more appropriate as an entity. Some relationships may be inaccurate, using the wrong modality or cardinality, and/or the relationships can be enhanced. Completely irrelevant ERD entity points Very appropriate and relevant entity. Very appropriate and accurate attributes assigned, including the primary key, and highly accurate relationships Somewhat appropriate entity. Somewhat appropriate and accurate attributes assigned, including the primary key, and/or somewhat accurate relationships. There are some attributes that are not clear or inappropriate, or there are missing attributes. For example, “marketing” is not likely to be an appropriate attribute. “Marketing” is also not a clearly defined entity. “Marketing department” is more appropriate as an entity. Some relationships may be inaccurate, using the wrong modality or cardinality, and/or the relationships can be enhanced. Completely irrelevant ERD entity points Very appropriate and relevant entity. Very appropriate and accurate attributes assigned, including the primary key, and highly accurate relationships Somewhat appropriate entity. Somewhat appropriate and accurate attributes assigned, including the primary key, and/or somewhat accurate relationships. There are some attributes that are not clear or inappropriate, or there are missing attributes. For example, “marketing” is not likely to be an appropriate attribute. “Marketing” is also not a clearly defined entity. “Marketing department” is more appropriate as an entity. Some relationships may be inaccurate, using the wrong modality or cardinality, and/or the relationships can be enhanced. Overall, the task is to demonstrate knowledge of database design supporting a functional area through an ERD with justification and explanation of your choices, using software tools to produce a professional diagram, and articulating how the design supports the business processes.