Assessment Brief: BIS1002 Data and Information Management Trimester-1 2021 Assessment 2: Applied Project-1 Due date:Week 7Group/individual:IndividualWord count / Time provided:2500 wordsWeighting:30%Unit Learning Outcomes:ULO-1, ULO-2, ULO-3 Assessment Details: Reline Engineering is an engineering firm with approximately 600 employees. A database is required to keep track of all employees, their skills, projects assigned, and departments worked in. … Continue reading “Data and Information Management | My Assignment Tutor”
Assessment Brief: BIS1002 Data and Information Management Trimester-1 2021 Assessment 2: Applied Project-1 Due date:Week 7Group/individual:IndividualWord count / Time provided:2500 wordsWeighting:30%Unit Learning Outcomes:ULO-1, ULO-2, ULO-3 Assessment Details: Reline Engineering is an engineering firm with approximately 600 employees. A database is required to keep track of all employees, their skills, projects assigned, and departments worked in. Every employee has a unique number assigned by the firm and is required to store his or her name and date of birth. If an employee is currently married to another employee of Reline Engineering., the date of marriage and who is married to whom must be stored; however, no record of marriage is required if an employee’s spouse is not also an employee. Each employee is given a job title (e.g., engineer, secretary, and so on). An employee does only one type of job at any given time, and we only need to retain information for an employee’s current job. There are 10 different departments, each with a unique name. An employee can report to only 1 department. Each department has a phone number. To procure various kinds of equipment, each department deals with many vendors. A vendor typically supplies equipment to many departments. We are required to store the name and address of each vendor and the date of the last meeting between a department and a vendor. Many employees can work on a project. An employee can work on many projects (Project A, Project B etc.), but he/she can only be assigned to at most one project in a given city. For each city, we are interested in its state and population. An employee can have many skills (preparing material requisitions, checking drawings, and so on), but she or he may use only a given set of skills on a particular project. (For example, an employee WILLIAMS may prepare requisitions for the Project D and prepare requisitions as well as check drawings for Project E.) Employees use each skill that they possess in at least one project. Each skill is assigned a number, and we must store a short description of each skill. Projects are distinguished by project numbers, and we must store the estimated cost of each project. Your assignment consists of two parts. Part 1. Conceptual Model Identify EntitiesIdentify entity supertypes and subtypes and their types, inheritance, and discriminators.Describe relationships between entities and their cardinalitiesIdentify entity primary keysDraw a Conceptual Model Entity-Relationship diagram Part 2. Logical Model Describe data attributes and their types for each entityRedesign the Conceptual model removing many-to-many relationships (if any)Identify primary, composite (if any) and foreign keys (if any) for each entityif there are any one-to-one relationships then describe themDraw a Logical Model diagram Marking Information: The assessments will be marked out of 100 and will be weighted 30% of the total unit mark. Marking CriteriaNot satisfactory (0-49%) of the criterion mark)Satisfactory (50-64%) of the criterion markGood (65-74%) of the criterion markVery Good (75-84%) of the criterion markExcellent (85-100%) of the criterion markDemonstrate an understanding and describe the Conceptual Model design processes (20%)Inadequate understanding and describing Conceptual Model design processBasic knowledge only of understanding and describing Conceptual Model design processExhibits breadth and depth of understanding and describing Conceptual Model design processExhibits accurate and detailed breadth and depth of understanding and describing Conceptual Model design processDisplays exceptional understanding of concepts and their practical application in Conceptual Model design processDemonstrate an understanding and describe the Logical Model design processes (20%)Inadequate understanding and describing Logical Model design processBasic knowledge only of understanding and describing ConceptualExhibits breadth and depth of understanding and describing ConceptualExhibits accurate and detailed breadth and depth of understanding and describingDisplays exceptional understanding of concepts and their practical application inModel design processModel design processConceptual Model design processConceptual Model design processDemonstrate understanding and skills of creating the Conceptual Model diagram (30%)Inadequate understanding and skills of creating the Conceptual Model diagramBasic understanding and skills of creating the Conceptual Model diagramExhibits breadth and depth of understanding and skills of creating the Conceptual Model diagramExhibits accurate and detailed breadth and depth of understanding and skills of creating the Conceptual Model diagramDisplays exceptional understanding and skills of creating the Conceptual Model diagramDemonstrate understanding and skills of creating the Logical model diagram (30%)Inadequate understanding and skills of creating the Logical Model diagramBasic understanding and skills of creating the Logical Model diagramExhibits breadth and depth of understanding and skills of creating the Logical Model diagramExhibits accurate and detailed breadth and depth of understanding and skills of creating the Logical Model diagramDisplays exceptional understanding and skills of creating the Logical Model diagram
