Database Analysis and Design
Implement the initial database design for the Enterprise Resource Planning conceptual model described by the following requirements in your selected RDBMS. You need to create the Entity-Relationship model to Database analysis, define tables, primary keys, foreign keys, additional descriptive fields (at least 2 for each entity - relationship tables do NOT need additional fields in all cases), and any attribute value constraints you need.
A Company SCHEDULEs one or more EMPLOYEEs to work zero, one, or two of three possible SHIFTs on a weekly basis.
An EMPLOYEE serves in one and only one of the following POSITIONs for any single shift : operator, supervisor, quality, designer.
Each EMPLOYEE accumulates HOURS WORKED for a four-week PAY PERIOD.
Each POSITION applies a weighting factor to the hourly rate assigned to the EMPLOYEE. You will be evaluated on:
1. The Feasibility, Flexibility, and Appropriateness of the Relationship you select between entities, including indication of the type of relationship
Submit your Entity-Relationship Diagram generated by the DBMS in file named: lastname.firstname.Project 01.jpg (or png or pdf or gif)
2. The Attributes and KEY fields you identify for each entity
Value Constraints you define for fields you select
Please save all of your EXPORT DATABASE CREATE code in a notepad (text) file with the extension .sql , and submit your file(s) using your last name as part of the file name in the following format: lastname.firstname.Project 01.sql
Data Population of at least 3 values for each table illustrating the relationships.
Please run a SELECT *FROM
; for each table, saving the results in a notepad (text) file with the extension .dat , and submit your file(s) using your last name as part of the file name in the following format:
lastname.firstname.Project 01.dat
Supply the SQL and result for the following queries:
Please save all of your EXPORT DATABASE CREATE code in a notepad (text) file with the extension .sql , and submit your file(s) using your last name as part of the file name in the following format: lastname.firstname.Project 01.rpt
List all the employees of type "operator" with their corresponding schedule for the next weekly shift(s).
Total the number of hours per week for the last four weekly shifts per operator and sort by the operator's last name.
Update Employee ID = 101 to Employee ID =1001. Display the Employee information and next weekly shift schedule before the update and after the update.
Related Questions in DBMS
In SQL Developer ONLY! Deliverables Include SQL scripts and screenshot of the results: D1. Create the following three user-defined roles that are shown in the table below and assign them the specified permissions for the ...
|
Instructions For decades, relational databases remained essentially unchanged; data was segmented into specific chunks for columns, slots, and repositories, also called structured data. However, in this Internet of Thing ...
|
Answer the following Question : Explain the difference between a database management system (DBMS) and a database. Are Microsoft Access, SQL Server, and Oracle examples of databases or database management systems (DBMS)?
|
SQL Query 1. How many products have standard price less than 1000? Query 2: Display all attributes for products made of "Cherry" from Product table w/o referring to column names. Query 3: Display all product names having ...
|
Q1. Given the following file for assignment worker.com, identify data anomalies that must be removed before data can be loaded in data warehouse. Worker_assignment ← -----------------on course web site File is available ...
|
Question: Find at least two academic sources that describe the movement of Enterprise resource planning (ERP) activities to the cloud. Discuss the types of ERP activities that can be conducted in the cloud and the pros a ...
|
Question : We can sort a given set of n numbers by first building a binary search tree containing these numbers (using TREE-INSERT repeatedly to insert the numbers one by one) and then printing the numbers by an inorder ...
|
The system development team at the XYZ Company is working on developing a new customer order entry system. In the process of designing the new system, the team has identified the following data entity attributes: Invento ...
|
SQL Write a SELECT statement that returns one column from the Vendor table named Full Name. Create this column from the VendorContactFName and VendorContactLName columns. Format it as follows: last name, comma, first nam ...
|
Question: 1. (a)- Consider that you are asked to design an entity relationship diagram based on the below scenario: A university consists of a number of departments (id, d_name) and each department offers some courses. A ...
|
|
-
4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered
Ask Experts for help!!
Looking for Assignment Help?
Start excelling in your Courses,
Get help with Assignment
Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.
Ask Now
Help with Problems, Get a Best Answer
Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate
|
Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p
|
Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As
|
Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int
|
Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As
|
|