Homework Answers
Company Database
1) Project Table: To store the project of the company
| Project_ID | Project_Name |
Project Id is a primary key.
2) Project_Employee_relation table: To store which project is assigned to which Employee
| Project_ID | Employee_ID |
3) Employee Table: To store Information Regarding Employee
| Employee_ID | Employee_Name | JOC_ID |
Employee_Id is a primary key
JOC_ID is a foreign key
JOC_ID is a Job Classification of an Employee. In the Employee table, we are storing only Job Classification ID and information related to Job Classification is stored in another table.
4) Job_Classification Table: To Store Job_Classification information for example like an electrical engineer , technician, etc.
| Job_Classification_ID | Job_Classification_Name |
Job_Classification_ID is the primary key
5) BillingInfo Table: To store the currency in which we are paying to the employee , price of job_classification as per unit bases.
| JOC_ID | Currency_ID | price | Unit_Id |
6) Currency Table: To store different currency like rupees, dollar, euro, etc
| Currency_ID | Currency_Type |
Currency_ID is the primary key.
7) Unit Table: To store information related to the unit like hourly, weekly, monthly, etc because some employees are paying on the basis of monthly and for some basis on weekly or hourly.
| Unit_ID | Unit_Type |
Unit_ID is a primary key.
8) Work_Info: To store which employee has worked for how many hours or days or week.
| Employee_ID | Unit_ID | Total |
Add Answer to:
Projects Case Study A construction company requires a database to record details about building projects. Each...
Projects inc. is an engineering firm with approximately 50 employees A database is required to keep...
Projects inc. is an engineering firm with approximately 50 employees A database is required to keep track of all employees, their skills, projects assigned and departments worked in. Every employee has a unique number assigned by the firm, required to store her or his name and data of birth. If an employee is currentty married to another employee of Projects tnc. the data of the marriage and who the employee is married to must be stored. Howeer no record of...
List all business rules listed on the case study
Granite Sales Company keeps information on employees and the departments that they work in. For each department, the department name, internal mail box number, and office phone extension are kept. A department can have many assigned employees, and each employee is assigned to only one department. Employees can be salaried employees, hourly employees, or contract employees. All employees are assigned an employee number. This is kept along with the employee’s name and address. For hourly employees, hourly wage and target...
Lab 4 – Logical Design Introduction: This lab is designed to practice database design concepts. Submission:...
Lab 4 – Logical Design Introduction: This lab is designed to practice database design concepts. Submission: For the scenario below, draw a logical design draft on the paper, and then draw the design in the computer using PG Modeler software. After that, export the model to PNG photo. Submit to Brightspace a word file that has a photo of the draft design (on the paper) and the PNG photo that is produced from the PG modeler. Database scenario: Assume that...
Create a crows foot erd using a specialization hierarchy if appropriate. Granite sales company keeps information...
Create a crows foot erd using a specialization hierarchy if appropriate. Granite sales company keeps information on its employees and the departments in which they work. For each department, the department name,internal mailbox server, and office phone extension are kept. A department can have many assigned employees, and each employee is assigned to only one department. Employees can be salaried, hourly, or work on contract. All employees are assigned an employee number, which is kept along with the employee's name...
Complete Job-Order Costing EYK 3-1 EYK3-1. Business Decision Case Elizabeth Flanigan and Associates is an engineering...
Complete Job-Order Costing EYK 3-1 EYK3-1. Business Decision Case Elizabeth Flanigan and Associates is an engineering and design firm that specializes in developing plans for recycling plants for municipalities. The firm uses a job costing system to accumulate the cost associated with each design project. Flanigan employs three levels of employee: senior engineers, associate engineers, and clerical staff. The salary cost of the senior engineers and the associate engineers is assigned to each project as direct labor. The salary cost...
Complete Job-Order Costing EYK 3-1 EYK3-1. Business Decision Case Elizabeth Flanigan and Associates is an engineering...
Complete Job-Order Costing EYK 3-1 EYK3-1. Business Decision Case Elizabeth Flanigan and Associates is an engineering and design firm that specializes in developing plans for recycling plants for municipalities. The firm uses a job costing system to accumulate the cost associated with each design project. Flanigan employs three levels of employee: senior engineers, associate engineers, and clerical staff. The salary cost of the senior engineers and the associate engineers is assigned to each project as direct labor. The salary cost...
create a Crows Foot ERD using specilization ERD
Problem 3. Given the following business scenario, create a Crow’s Foot ERD using a specialization hierarchy if appropriate. Granite Sales Company keeps information on employees and the departments that they work in. For each department, the department name, internal mail box number, and office phone extension are kept. A department can have many assigned employees, and each employee is assigned to only one department. Employees can be salaried employees, hourly employees, or contract employees. All employees are assigned an employee number. This...
The Ch07_ConstructCo database stores data for a consultingcompany that tracks all charges to projects. The...
The Ch07_ConstructCo database stores data for a consulting company that tracks all charges to projects. The charges are based on the hours each employee works on each project. The structure and contents of the Ch07_ConstructCo database are shown in Figure P7.1.Note that the ASSIGNMENT table in Figure P7.1 stores the JOB_CHG_HOUR values as an attribute (ASSIGN_CHG_HR) to maintain historical accuracy of the data. The JOB_CHG_HOUR values are likely to change over time. In fact, a JOB_CHG_ HOUR change will be...
The owner of a small chain of appliance stores wants to build a database to help...
The owner of a small chain of appliance stores wants to build a database to help track data about its regions, stores, employees and jobs. The chain has divided the map of where its stores exists into various regions. Each region has a description (of boundaries). Each store is named, has an average market size (expressed in dollars) and belongs to s specific region. Each store also has an address, city, state, and zip. The database should...
Crows Foot ERD for Granite Sales
Given the following business scenario, create a Crow’s Foot ERD using a specialization hierarchy if appropriate. Granite Sales Company keeps information on employeesand the department that they work in. For each department, the department name, internal mail box number, and office phone extension are kept. A department can havemany assigned employees, and each employee is assigned to only one department. Employees can salaried employees, hourly employees, or contract employees. All employeesare assigned an employee number. This is kept along with...
Projects inc. is an engineering firm with approximately 50 employees A database is required to keep track of all employees, their skills, projects assigned and departments worked in. Every employee has a unique number assigned by the firm, required to store her or his name and data of birth. If an employee is currentty married to another employee of Projects tnc. the data of the marriage and who the employee is married to must be stored. Howeer no record of...
Most questions answered within 3 hours.
-
(63
#14)
which of the following statments best describes how chamging
the concentration of the substances...
asked 3 hours ago -
In the following reaction, which element is undergoing
oxidation: Na2SO3 + N2O --> N2 + Na2SO4...
asked 3 hours ago -
Which of the following pairs of ions have the same electron
configuration?
I: Br− and Se2−...
asked 6 hours ago -
The Foremost Composite Materials Company is planning a two-day
sales conference for October 19-20. The conference...
asked 6 hours ago -
3) Illustrate the observed pattern of relatedness of organisms
versus adaptations to specific conditions. This means...
asked 7 hours ago -
In winter a lake has a 0.35 m thick ice layer over 1.10 m of
water....
asked 8 hours ago -
Assuming the following has been encrypted with a Vigenere cipher
below, use the method(s) and assumptions...
asked 8 hours ago -
How would I use switch statements to write a program that will
take an input of...
asked 8 hours ago -
Imagine a reaction in which methane gas combusts at a constant
pressure of 1 atm and...
asked 8 hours ago -
Two parallel wires (each 12 m in length) are separated by a
distance of 0.065 m...
asked 8 hours ago -
Suppose there were three masses at the corner of uniform
equilateral triangle. The masses are m1...
asked 8 hours ago -
Situation: A building that is 618 m above the ground floor. How
many times would a...
asked 8 hours ago