Design database for company organized into departments

Assignment Help Database Management System
Reference no: EM1369920

Suppose that, after the requirements collection and analysis phase, the database designers stated the following dimension of the "miniworld"- to be represented in the Company Supplier-Part database:

1. The company is organized into departments. Each department has a unique name, a unique number. A department may have several locations, and may have number of employees work in it.
2. Each employee is identified by unique number (EMP#), and we store the employee's name, address, salary, gender, and birth-date. An employee is assigned to one department but may work on several project. We keep track of the number of hours per week that an employee works on each project.
3. We want to keep track of the dependents of each employee for insurance pur­poses. We keep each dependent's name, sex, birthdate, and relationship to the employee.
4. Each project has a unique name, a unique number (PRJ#), and a single location, and a particular employee who manages the project. We keep track of the start date when that employee began managing the project.
5. We keep track of the suppliers (more accurately, suppliers under contract), who supply parts (more accurately, kinds of parts required by a project) to the projects. Each supplier has a unique supplier number (SPL#), a supplier name; rating or status value (STATUS); and a location (CITY). We assume that each supplier is located in exactly one city.
6. Each kind of part has a part number (PRT#), which is unique; a part name, a color, weight, and a location where parts of that kind are stored (CITY). We assume where it makes any difference that part weights are given in kilograms. We also assume that each kind of part comes in exactly one color and is stored in a warehouse in exactly one city.
7. We keep track of each shipment of parts by the supplier to a project, and we store the quantity of each part in a particular shipment.
8. The supplier may supply many parts and a part may supplied by several suppliers

Reference no: EM1369920

Questions Cloud

Show the operations and supply management : Evaluate the total productivity measure and the partial measure for labor, capital, and raw materials for this company for both years and what do these measures tell you about this company
Questions about monoplies : A monopoly is manufacturing a level of output at which price is $80, marginal revenue is $40, average total expenses is $100, marginal cost is $40and average fixed cost is $10.
What are some things ceo did to turn hp around : What are some things CEO Hurd did as CEO to turn Hewlett Packard around - Show some of the main initiatives (related to Organizing) that CEO Hurd has implemented in order to turn HP around?
Comparing the new equilibrium income and interest rate : If the Federal Reserve where ready to cut interest rates next week and officials indicated today that quarter-point cut in federal funds remains firmly on table, despite market expectations of half point cut.
Design database for company organized into departments : Database designers stated following dimension of "miniworld"- to be represented in Company Supplier-Part database: company is organized into departments. Each department has unique name, unique number.
Short run competitive equilibrium : If the total expense schedule for a perfectly competitive firm is and if market price is $60, how many units of putput will the company produce?
Research current leadership styles : Recognize situations that present potential ethical and legal issues and develop solutions for those issues and research current leadership styles and strategies in management.
Determine the short run impact of price ceiling : Assume the government imposes a fixed tax t per unit quantity on each firm. Explain the impact of this tax on following variables;
Long-run demand curve for labour : What happens to the long-run demand curve for labour if the demand for the firm's output increases and what happens to the long-run demand curve for labour if the price of capital increases?

Reviews

Write a Review

 

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd