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

  Indicate change to make original premiere products database

Indicate the changes (using the shorthand representation) that you would need to make to the original premiere products database desing to support the following requirements.

  Role and tasks performed by database administrator

In 250 - 300 words describe role of a database administrator and the tasks performed by this role. Also, describe why this role is important in Database Management.

  Entity-relationship diagram

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

  Create a database using oracle packaged procedure

Create a database using Oracle packaged procedure

  Draw an entity relationship diagram for the system

Draw an Entity Relationship diagram for the system and Identify the table design for the database displaying all the fields/attributes. Ensure that all tables are in 3NF. You also need to identify the primary keys and foreign keys, where applicable..

  Completing transaction using sql

Write down the complete transaction using SQL.

  Create library database schema structure

The library System stores 3 type of informations: Users ( USID, USNAME, USMob, USEmail, USDept,USStartDate, NofBooks). Create the library database schema Structure.

  Write the functional dependencies in the table

Write the functional dependencies in the table which concerns invoicing (an application Premiere Products is considering adding to its database), subject to the specified conditions.

  Explain meaning of expression acid transaction

What is lock granularity? Explain the use of BEGIN, COMMIT, and ROLLBACK TRANSACTION statements. Explain the meaning of expression ACID transaction.

  Writing down sql query

Write down the SQL code in order to carrying out the following requests. Display all the data in each of the four tables. Do not display the foreign key columns.

  Database modeling and design

Database Modeling and Design: A complete table diagram. Transform model to tables, include all attributes and keys.

  Design and build a prototype data warehouse

Design and build a prototype data warehouse using the data on Spend over £25,000 in the Science and Technology Facilities Council

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