Implement the initial database design for the enterprise

Question

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.

View Complete Question

Solution Preview :

Prepared by a verified Expert

Database Management System: Implement the initial database design for the enterprise

Reference No:- TGS01720321

Now Priced at $40 (50% Discount)

Recommended (99%)

Rated (4.3/5)

Have a Question? (oR Write a Review)

Write atleast 100 words!!

   Recent Questions Asked Database Management System

Q : What is the value of the line integral of the earths 1 how do you find the exact value of the line integral2 what is the physical significance of the line integral of the

Q : For what orientation of the infinitesimal surface relative 1 what is the magnetic flux crossing an infinitesimal surface oriented parallel to the magnetic flux density vector2

Q : Make an investment recommendation you should not share your make an investment recommendation you should not share your final recommendation with your classmates assume you have

Q : Provide physical interpretations for the closed surface 1 how do you find the approximate value of the surface integral over a given surface2 how do you find the exact value

Q : Implement the initial database design for the enterprise database analysis and designimplement the initial database design for the enterprise resource planning conceptual model

Q : To find the induced emf around a planar loop is it 1 why is it necessary to have the minus sign associated with the time rate of increase of magnetic flux on the right

Q : A major real estate chinese investment firm is studying its risk management assessmenta major real estate chinese investment firm is studying its jump across thepacific 5 billion

Q : How would you orient a loop antenna in order to obtain 1 discuss briefly the motional emf concept2 what is lenzs law3 how would you orient a loop antenna in order to obtain

Q : Determine the total discount or premium for each issue- the initial proceeds per bond the size of the issue the initial maturity of the bond and the years remaining to