Reference no: EM133675021
IT Project Management
Tutorial
Entity Relationship Modelling
How would you graphically identify each of the following ERM components in a Crow's Foot notation with example?
An entity
The cardinality (0, N)
A weak relationship
A Strong Relationship
Discuss the difference between a composite key and a composite attribute. How would each be indicated in an ERD?
The local city youth league needs a database system to help track children that sign up to play soccer. Data needs to be kept on each team and the children that will be playing on each
team and their parents. Also, data needs to be kept on the coaches for each team. Draw the data model described below.
Entities required: Team, Player, Coach, and Parent. Attributes required:
Team: Team ID number, Team name, and Team colors.
Player: Player ID number, Player first name, Player last name, and Player age.
Coach: Coach ID number, Coach first name, Coach last name, and Coach home phone number.
Parent: Parent ID number, Parent last name, Parent first name, Home phone number, and Home Address (Street, City, State, and ZIP Code).
The following relationships must be defined:
Team is related to Player.
Team is related to Coach.
Player is related to Parent.
Connectivities and participations are defined as follows:
A Team may or may not have a Player.
A Player must have a Team.
A Team may have many Players.
A Player has only one Team.
A Team may or may not have a Coach.
A Coach must have a Team.
A Team may have many Coaches.
A Coach has only one Team.
A Player must have a Parent.
A Parent must have a Player.
A Player may have many Parents.
A Parent may have many Players.
What is Derived attribute? Explain with example.
Write the business rules reflected in the conceptual model shown in Fig 1.
Activity - 4
Question 1: From the following information, develop an AON project network. Complete the forward and backward pass, compute activity slack, and identify the critical path. How many days will the project take?
| ID |
Description |
Predecessor |
Time |
| A |
Survey site |
None |
2 |
| B |
Install drainage |
A |
5 |
| C |
Install power line |
A |
3 |
| D |
Excavate site |
B, C |
4 |
| E |
Pour foundation |
D |
3 |
Question 2: You are tasked with planning and managing a software development project for creating a new mobile application. The project involves several phases and activities. Your task is to use any Project Management Software tool to create a Gantt Chart to visualize the project timeline and schedule. A screenshot of your Gannt Chart is needed. This screenshot must show the date and time from the task bar of your PC or Laptop.
The project consists of the following main activities and their durations: Requirements Gathering: 5 days.
Design and Prototyping: 10 days. Development: 20 days.
Testing and Quality Assurance: 15 days. Deployment and Launch: 5 days.
Additional Information:
The project must start on April 10, 2024. Include the start and end dates for each activity.
Design and Prototyping cannot start until Requirements Gathering is complete.
Development cannot start until Design and Prototyping is complete.
Testing and Quality Assurance cannot start until Development is complete.
Deployment and Launch cannot start until Testing and Quality Assurance is complete.