A department employs up to thirty employees, but an employee is employed by one department. For...

A department employs up to thirty employees, but an employee is employed by one department. For each employee you need to store unique employee Id, name, address and salary. Departments are identified by department Id and also have a name. Some employees are not assigned to any department. A division operates many departments, but each department is operated by one division. An employee may be assigned at the most three projects, and a project may have at the most six employees assigned to it. A project may have at least one employee assigned to it. Each project is identified by unique name and has a budget. A project can be related to other projects. There can be many related projects. One of the employees manages each department, and each department is managed by only one employee. One of the employees runs each division, and each division is run by only one employee. For each division, store unique Id and name.

REQUIRED:

a) Design a conceptual diagram from the above information.

b) Develop a logical data model for the database.

c) Explain the importance of data modelling.

Expert Solution

Importance of data modeling :

Data models work as a simplified abstraction of reality. In a real hospital, each patient is different and must be treated individually. In software, however, we talk about an abstract patient. The same applies for restaurants and any other field. Each time, you need to make decisions about what information is important and should be included in the data model and what to omit. In a hospital, you should know the gender of the patient. But the gender of the same person won’t be of much importance in a restaurant. In complex applications, you often need to answer hundreds of such questions before you write a single line of code.

Data modeling makes it easier to integrate high-level business processes with data rules, data structures, and the technical implementation of your physical data. Data models provide synergy to how your business operates and how it uses data in a way that everyone can understand.

#follow providing conceptual diagram and logical data model

Logical data model diagram::

venereology answered 2 hours ago

A) Using the scenario described by “Each store employs one or more employees; each employee is...

A) Using the scenario described by “Each store employs one or more employees; each employee is employed by one store”, work the following problems: 1. Identify each entity. 2. Identify each relationship type. Justify your answer. 3. Create the basic Crow's Foot ERD using Visio. B) Using the scenario described by “A job assignment can be assigned to more than one employee at a time; each employee can have only one job assignment”, work the following problems: 1. Identify each...

List department name, employee id, and employee name for all employees in department name order. Repeat...

List department name, employee id, and employee name for all employees in department name order. Repeat for department #10 only. List the course ID, course name, section, instructor name, day, time, and room for all course sections. List the course ID, course name, section, student ID, and student name for CRN 1003. Display the list in ascending order of student last and first names. DROP TABLE registration; DROP TABLE sections; DROP TABLE courses; DROP TABLE students; DROP TABLE instructors; CREATE...

It is common for an organization to have different categories of employees, such that one Employee...

It is common for an organization to have different categories of employees, such that one Employee class can not easily describe all types of Employees.In this project, you will code a basic Employee class, and then a number of classes which derive from the Employee class (inherit), adding Employee specifics. An application program which stores info for one company will have use objects of different types to model the all employees. Part I: The Employee Class First create the Employee...

The overseeing surveyor did not advise the HR department when an employee resigned. All employees are...

The overseeing surveyor did not advise the HR department when an employee resigned. All employees are paid by direct credit to their bank accounts unless any variations are notified to the HR department. In this particular case the employee’s salary continued to be paid into her bank account for a further two months. Discuss a control that should have prevented the situation and the audit risk that exists if the situation is not discovered. Investigate and discuss a substantive audit...

Tipped Employees A tipped employee is one who engages in an occupation in which tips of...

Tipped Employees A tipped employee is one who engages in an occupation in which tips of more the $30 a month are customarily and regularly received. An employer may consider, within prescribed limits, the tips received by a tipped employee as part of the employee's wages. In 1996, the Small Business Job Protection Act froze the minimum cash wage required for tipped employees at $ per hour. If the employee receives more than $/month in tips, the employee is required...

A male employee was hired by a company with more than 15 employees. Approximately one year...

A male employee was hired by a company with more than 15 employees. Approximately one year into the employment the employee told his supervisor that he was a transsexual and came dressed to a party as a woman. The employee then announced he would be transitioning from a male to a female. This meant she would be coming to the office dressed as a woman and would legally adopt a female name. Following this announcement the employee was terminated. The...

5. Thirty percent of the employees of a large company are minorities. A random sample of...

5. Thirty percent of the employees of a large company are minorities. A random sample of 8 employees is selected. (Total: 7 marks; a-c: 2 marks each, d: 1 mark) a. What is the probability that the sample contains exactly 7 minorities? b. What is the probability that the sample contains less than 5 minorities? c. What is the probability that the sample contains exactly 1 non-minority? d. What is the expected number of minorities in the sample

Scenario: Walter Joss is one of the best employees in your department, a smart and hard...

Scenario: Walter Joss is one of the best employees in your department, a smart and hard worker with a keen mind for business. His upbeat attitude has helped the entire department get through some rough times recently. On a personal level, his wise counsel helped you grow into a leadership role when you were promoted to marketing manager several years ago. You generally welcome Walter's input on the department's operations, and you have implemented several of his ideas to improve...

In R-Syntax, create a vector of 100 employees ("Employee 1", "Employee 2", ... "Employee 100") [Hint:...

In R-Syntax, create a vector of 100 employees ("Employee 1", "Employee 2", ... "Employee 100") [Hint: use the `paste()` function and vector recycling to add a number to the word "Employee"] then create a vector of 100 random salaries for the year 2017 [Use the `runif()` function to pick random numbers between 40000 and 50000] and finally create a vector of 100 salary adjustments between -5000 and 10000 [use runif() to pick 100 random #'s in that range]

A. A new shopping mall is considering setting up an information desk manned by one employee....

A. A new shopping mall is considering setting up an information desk manned by one employee. Based on information obtained from similar information desks, it is believed that people will arrive at the desk at the rate of 20 per hour. It takes an average of 2 minutes to answer a question. It is assumed that arrivals are Poisson and answer times are exponentially distributed. i. Find the probability that the employee is idle. ii. Find the proportion of the...

Question