What is an overlapping subtype

Reference no: EM133680282

Project Management

Activity:

Question 1: You have been tasked with leading an IT project to design a new website for a local bakery. The project aims to create an online presence for the bakery, increase customer engagement, and showcase its products and services. Your task is to use any tool to develop a Work Breakdown Structure (WBS) for this project. Try to identify all the major components and provide three levels of detail. A screenshot of your WBS is needed. This screenshot must show the date and time from the task bar of your PC or Laptop

Question 2: The organizing committee for the Spring Music Festival has identified the following potential risks to their event:

Musicians failing to show up for scheduled performances
Clashes between attendees
Disruptive behaviour by intoxicated attendees
Performer sustaining a serious injury during a show.

How would you recommend that they respond to these risks (i.e., mitigate, avoid, transfer, share, retain) and why?

Question 3: You are leading a software development project for a new mobile application that aims to revolutionize the way users manage their personal finances. The application will allow users to track expenses, create budgets, and set financial goals, with a user-friendly interface accessible across multiple devices. The project has a tight deadline due to market demand and investor expectations, and it involves complex technical requirements such as real-time synchronization, data encryption, and integration with third-party financial institutions. Identify three potential risks specific to this IT project and develop a contingency plan for each risk. Show your results in the form of a Risk Response Matrix which was discussed in the lecture today.

Follow APA 7th

Advanced Data Modelling

Question 1: What is an entity supertype, and why is it used?

Question 2: Describe what is meant by a specialisation hierarchy?

Question 3: What is a subtype discriminator? Given an example of its use.

Question 4: What is an overlapping subtype? Give an example.

Question 5: What is a disjoint subtype? Give an example

Question 6: What is the difference between partial completeness and total completeness?

Question 7: Given the following business scenario, create a Crow's Foot ERD using a specialization hierarchy if appropriate.

Two-Bit Drilling Company keeps information on employees and their insurance dependents. Each employee has an employee number, name, date of hire, and title. If an employee is an inspector, then the date of certification and the renewal date for that certification should also be recorded in the system. For all employees, the Social Security number and dependent names should be kept. All dependents must be associated with one and only one employee. Some employees will not have dependents, while others will have many dependents.

Question 8: Given the following business scenario, create a Crow's Foot ERD using a specialization hierarchy

if appropriateGranite Sales Company keeps information on employees and the departments that they work in. For each department, the department name, internal mailbox number, and office phone extension are kept. A department can have many assigned employees, and each employee is assigned to only one department. Employees can be salaried employees, hourly employees, or contract employees. All employees are assigned an employee number. This is kept along with the employee's name and address. For hourly employees, hourly wage and target weekly work hours are stored (e.g., the company may target 40 hours/week for some, 32 hours/week for others, and 20 hours/week for others). Some salaried employees are salespeople that can earn a commission in addition to their base salary. For all salaried employees, the yearly salary amount is recorded in the system. For salespeople, their commission percentage on sales and commission percentage on profit are stored in the system. For example, John is a salesperson with a base salary of $50,000 per year plus 2- percent commission on the sales price for all sales he makes plus another 5 percent of the profit on each of those sales.

For contract employees, the beginning date and end dates of their contract are stored along with the billing rate for their hours.

Reference no: EM133680282

Questions Cloud

What fintech companies are doing in nigeria : Explain what is being done, for example, how changes are being made, issues addressed in detail, action taken, e.g. what fintech companies are doing in Nigeria

How do you decide what are the important diversity : How do you decide what are the important diversity and inclusion issues in different countries?

Utilize instrumental theory and structural theory : What is a real-world example that demonstrates a push to control certain socioeconomic classes according to instrumental theory?

Share what it was like for you to read crucifixion of jesus : Share what it was like for you to read the crucifixion of Jesus. Provide clarification to classmates' questions and insight into the discussion.

What is an overlapping subtype : What is an overlapping subtype? Give an example.What is the difference between partial completeness and total completeness

Determining an offenders needs for treatment : Determining an offender's needs for treatment is undeniably superior to a subjective or personal approach within the criminal corrections system.

What is a disjoint subtype : What is a disjoint subtype and What is the difference between partial completeness and total completeness

What are the competitive advantages of business : What are the competitive advantages of business/organizations being environmentally aware and active?

What can companies do to create and reinforce a culture : Do you think that culture is important to organizational performance? Why or why not? What can companies do to create and reinforce a culture of inclusion?

User Account

All Pages