Provide the entity relationship diagram

Assignment Help Database Management System

Reference no: EM132111163

You will provide the Entity Relationship Diagram (ERD) that captures the following requirements:

The hospital has many employees, for each employee we keep the ID (unique), first, and last names, job title, salary, and the office number.

Employees have three categories, regular employees, division managers where each one manages several regular employees, and general managers where each one manages several division managers. The three categories of employees share the same attributes mentioned above.

Reference no: EM132111163

Questions Cloud

How exception handling can be used to solve the problem : You don't need to be overly detailed, just make sure you could use exception handling to solve it.

Describe the relationship and discuss if the disjoint rule : Describe the relationship and discuss if the disjoint or overlap rule would apply to your example.

Analyze the best algorithm for sorting an array : Provide the running time and pseudocode to analyze the best algorithm for sorting an array of n very very large numbers in the range 1 through n.

The identification of cardinality between entities : An inspection occurs at a particular date and time, with a numeric score from 1 to 5, and notes about the outcome of the inspection.

Provide the entity relationship diagram : The hospital has many employees, for each employee we keep the ID (unique), first, and last names, job title, salary, and the office number.

Write down the network prefix of each subnetwork : Of the 5 subnets, select the 1st one and write down the first usable address, the last usable address, and the broadcast address.

Describe how you would work around the types limitations : Provide five specific examples of data that cannot be stored within Java's eight primitive data types.

Provide an original example of proper normalization : Provide an original example of proper normalization and one for poor normalization. Include SQL operations that would be more/less efficient for the examples.

Provide one scenario involving a natural disaster : Provide one scenario involving a natural disaster where your contingency plan would be tested.

User Account

All Pages