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
SQL Assignment In these exercises, you'll enter and run your own SELECT statements. You will use the MyGuitarShop database for these queries. If you do not already have the MyGuitarShop database, the SQL script and the i ...
|
Question: Create an ERD for the following scenario. A small company ABC wants a database to keep track of internal company information. Â Given the following information create an ERD. The ABC Company has several departm ...
|
The relation Member(StudentId, OrganizationId, RoleId) stores the membership information of student joining organization. For example, ('S1', 'O2', 'R3') indicates that student with Id 'S1' joined the organization with i ...
|
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 ...
|
In this section, the student is required to develop a technical debate based on his/her understanding using available scientific literature. The answer to this question should not exceed three A4 Pages. In the traditiona ...
|
Question: Create the physical data model for the logical data model that you submitted in IP3. This should include all of the data definition language SQL. Your submission should include all DDL needed to: Create the tab ...
|
Question : Talk about the importance of pulling data from worksheets into a single sheet also the ways excel could be a solution to a complex challenge. The response must be typed, single spaced, must be in times new rom ...
|
Tableau is business intelligence software that helps people see and understand their data. Fast Analytics Connect and visualize your data in minutes. Tableau is 10 to 100x faster than existing solutions. Ease of Use Anyo ...
|
Question: As explained throughout this course, entity relationship modeling is a critical element of database design. If the database is not properly modeled, it is unlikely that the database will be properly developed. ...
|
Suppose that you have designed a database for Morgan Importing that has the following tables: EMPLOYEE (EmployeeID, LastName, FirstName, Department, Phone, Fax, EmailAddress) STORE (StoreName, City, Country, Phone, Fax, ...
|
|
-
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
|
|