Construct a Database of Acme Company: The Acme Company wants to construct a database to keep track
Fantastic news! We've Found the answer you've been seeking!
Question:
Construct a Database of Acme Company:
Transcribed Image Text:
The Acme Company wants to construct a database to keep track of the company's employees, departments, and projects as well as the employee's dependents. The requirements collected to date to be modeled are: 1. 2. 3. 5. 6. 4. Every employee is assigned to a department but may work on several projects, which are not necessarily under the control of the same department. 7. The company is organized into departments. Each department has a name, a number, and an employee who manages the department. 8. A department controls a number of projects, each of which has a name, a number, and a start date but not all departments have projects assigned to them. We store each employee's name, social security number, address, salary, sex, and birth date. We keep track of the number of hours per week that each employee works on each project. For most projects, a team of employees is assigned to work on the project while some employees are never assigned to a project. We also keep track of the direct supervisor of each employee. We want to keep track of the dependents of each employee, if they have any, for insurance purposes. We keep each dependent's name, sex, birth date, and relationship to the employee. The Acme Company wants to construct a database to keep track of the company's employees, departments, and projects as well as the employee's dependents. The requirements collected to date to be modeled are: 1. 2. 3. 5. 6. 4. Every employee is assigned to a department but may work on several projects, which are not necessarily under the control of the same department. 7. The company is organized into departments. Each department has a name, a number, and an employee who manages the department. 8. A department controls a number of projects, each of which has a name, a number, and a start date but not all departments have projects assigned to them. We store each employee's name, social security number, address, salary, sex, and birth date. We keep track of the number of hours per week that each employee works on each project. For most projects, a team of employees is assigned to work on the project while some employees are never assigned to a project. We also keep track of the direct supervisor of each employee. We want to keep track of the dependents of each employee, if they have any, for insurance purposes. We keep each dependent's name, sex, birth date, and relationship to the employee.
Expert Answer:
Answer rating: 100% (QA)
Based on the requirements provided we can design a relational database schema to represent the Acme ... View the full answer
Related Book For
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
Posted Date:
Students also viewed these databases questions
-
What would be the journal entry (specifically the accounts) to record this additional future restoration cost (previous question) but under ASPE requirements?
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Googles ease of use and superior search results have propelled the search engine to its num- ber one status, ousting the early dominance of competitors such as WebCrawler and Infos- eek. Even later...
-
Laval produces lighting fixtures. Budgeted Information for Its two production departments follows. The departments use machine hours (MH) and direct labor hours (DLH). Overhead cost Direct labor...
-
Lower-of-Cost-or-Market Garcia Home Improvement Company installs replacement siding, windows, and louvered glass doors for single family homes and condominium complexes in northern New Jersey and...
-
Consider the data set in DS 6.6.5 of bamboo shoot heights 40 days after planting. Use a computer package to construct 90%, 95%, and 99% two-sided /-intervals for the mean shoot height. A previous...
-
Show that, in Figure 7.26, the change in potential energy along a round trip from position \(x_{1}\) to position \(x_{2}\) and then back to \(x_{1}\) is zero. Figure 7.26 (a) Cart moves directly from...
-
The Bawl Corporation supplies alloy ball bearings to auto manufacturers In Detroit. Because of its specialized manufacturing process, considerable work-in -process and raw materials are needed. The...
-
Trying to break an encryption key by trying every possible combination of characters is called what? 1 point A social engineering attack A brute force attack A rainbow table attack A known cyphertext...
-
Use Nodal Analysis to find Vx, in the circuit. 202 4A -2 A Va VB 50 N 40 2 100 2 25 2 10 A
-
Differentiate the function. s'(t) = s(t) = 9t 2(3t4 + 7)
-
Write a program SubsetSum that reads 1ong integers from standard input, and counts the number of subsets of those integers that sum to exactly zero. Give the order of growth of the running time of...
-
Modify BST to add methods \(\min ()\) and \(\max ()\) that return the smallest (or largest) key in the table (or nu17 if no such key exists).
-
Katz Hat Shop received a shipment of hats for which it paid the wholesaler $2,970. The price of the hats was $3,000, but Katz was given a $30 cash discount and required to pay freight charges of $50....
-
Given an array of \(n\) integers, design an algorithm to determine whether any three of them sum to 0 . The order of growth of the running time of your program should be \(n^{2} \log n\). Extra...
-
Write a program to generate random connected graphs and 2-ring graphs with random shortcuts. Using SmallWorld, generate 500 random graphs from both models (with 1,000 vertices each) and compute their...
-
What is the number? 9 subtracted from the quotient of a number x and 4 is 5. M Enter
-
Read Case Study Google: Dont Be Evil Unless and answer the following: Given its mission of providing information to the world, should Google censor searches in China?
-
Interview systems and database analysts at this organization. Ask them to describe their systems development process. Which does it resemble more: the systems development life cycle or prototyping?...
-
Explain three conditions that suggest a surrogate key should be created for the primary key of a relation.
-
Create a star schema for this case study. How did you handle the time dimension? Fitchwood Insurance Company, which is primarily involved in the sale of annuity products, would like to design a data...
-
Light of a single wavelength is incident on a diffraction grating with \(500 \mathrm{slits} / \mathrm{mm}\). Several bright fringes are observed on a screen behind the grating, including one at...
-
The shiny surface of a CD is imprinted with millions of tiny pits, arranged in a pattern of thousands of essentially concentric circles that act like a reflection grating when light shines on them....
-
If sunlight shines straight onto a peacock feather, the feather appears bright blue when viewed from \(15^{\circ}\) on either side of the incident beam of sunlight. The blue color is due to...
Study smarter with the SolutionInn App