Normalization 3nf

I need support with this Computer Science question so I can learn better.

Struggling to find relevant content or pressed for time? – Don’t worry, we have a team of professionals to help you on
Normalization 3nf
Get a 15% Discount on this Paper
Order Now

Please show all of your work/steps

Provide a complete integrated set of normalized (3NF required) relations for The Data Structuring/Normalization Scenario in this link. Use the format displayed in An Example of Normalization below.

Note that entities are in all caps, attribute names with multiple words

are connected by an underline character joining each word, primary keys

are underlined and

listed first within the attributes in Third Normal Form (see textbook

Chapter 9 for explanatory information on the normalization process).

An Example of Normalization:

Here is a relatively simplistic example of a normalization process:

An “un-normalized” relation:

STUDENT(Last_Name, First_Name, Course_Name, Instructor_Name, Semester, Year)

The “normalized” version in Third Normal Form:

STUDENT(Student_ID, Last_Name, First_Name)

INSTRUCTOR(Instructor_ID, Last_Name, First_Name)

COURSE(Course_ID, Course_Name)

SEMESTER(Semester_ID, Term, Year)

COURSES_TAKEN(Student_ID,Course_ID,Instructor_ID,Semester_ID)

The Data Structuring/Normalization Scenario:
Your Team has been hired by a manufacturing company with multiple manufacturing facilities to perform the logical design of a relational database to manage their roster of available temporary workers and their subsequent assignments to fill workforce needs. The temporary workers are needed on a seasonal basis to fill a number of job roles such as materials management, van driver, loading/shipping dock worker, assembly line worker, packaging/shipping support, etc. Each manufacturing facility is configured with three different work areas, which are raw materials management, assembly line productions, and packaging/shipping. Here are the requirements that you have identified after interviewing company management:
1. The company would like to record and maintain complete information on each temporary worker, including full name, home address, mailing address (which may or may not differ from the home address), preferred and secondary telephone numbers, email address, date of birth, gender, initial date of employment.

2. The manufacturing facilities all operate on a 24-hour daily basis, three 8-hour shifts a day, six days a week, Monday through Saturday. They would also like to maintain information on each temporary worker’s work shift availability in terms of days of the week and work shift, which is first shift, second shift, third shift, or “bridge” shift. A bridge shift is composed of the last 4 hours of first shift and first 4 hours of second shift on the specified days. Workers may specify availability for one or more shifts during specified days of the week.

3. In addition, they will need to maintain complete information on each temporary worker’s job certifications and information on certification instructors. The information for certification instructors is the same information as for temporary workers identified in item 1 above, information on which courses they are qualified to teach, and their teaching histories for the company. A temporary worker must be certified for a job role by completing a required training program for that role and can be certified to perform one or more job roles. For job certifications, the company would like to maintain the identification of the certification, identification of the temporary worker participating in the certification training, the dates of certification training (certification training ranges from 4 to 16 hours depending on the type of certification), the certification trainer’s identification, and a pass/fail designation for the temporary worker completing the certification training. The company would also like to maintain complete information on available job role certification training program courses. 4. Temporary workers are also required to specify prioritized work area location preferences for one or more manufacturing locations. 5. Finally, they have stated the requirement for maintaining a complete record of each temporary worker’s assignments, including manufacturing facility location and work area assignment, date worked, shift(s) worked, and job role(s) filled by shift.
The company intends to use the completed database design to support the identification of temporary workers to fill needed assignments and to produce comprehensive reports on the use of temporary workers.

RECOMMENDED: [SOLVED] Normalization 3nf

order

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
$0.00
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
Sign up, place your order, and leave the rest to our professional paper writers in less than 2 minutes.
step 1
Upload assignment instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
s
Get personalized services with MyCoursebay
One writer for all your papers
You can select one writer for all your papers. This option enhances the consistency in the quality of your assignments. Select your preferred writer from the list of writers who have handledf your previous assignments
Same paper from different writers
Are you ordering the same assignment for a friend? You can get the same paper from different writers. The goal is to produce 100% unique and original papers
Copy of sources used
Our homework writers will provide you with copies of sources used on your request. Just add the option when plaing your order
What our partners say about us
We appreciate every review and are always looking for ways to grow. See what other students think about our do my paper service.
Nursing
Thank you so much. I didn't know where to start and you did an amazing job. Thanks and have a great night.
Customer 452925, March 16th, 2023
Human Resources Management (HRM)
Great Paper!
Customer 452701, August 1st, 2023
Philosophy
The paper is great. Will definitely use again.
Customer 452773, May 24th, 2022
Nursing
Awesome work!!!!!!
Customer 452453, March 24th, 2021
Nursing
They research and provide the best and up-to-date information..
Customer 452707, June 27th, 2023
Nursing
A-1 service every single time!!!
Customer 452453, July 27th, 2021
Social Work and Human Services
Great Work!
Customer 452587, August 31st, 2021
Technology
Great job on the paper!!
Customer 452885, December 14th, 2022
Human Resources Management (HRM)
Thanks for your assistance and promptness.
Customer 452701, November 1st, 2022
Nursing
Looks good. Thank you!!
Customer 452525, April 27th, 2022
Nursing
Always a job well done. I really appreciate the hard work.
Customer 452453, January 4th, 2021
Technology
Great job on the paper!
Customer 452885, December 28th, 2022
OUR GIFT TO YOU
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat

Good News ! We now help with PROCTORED EXAM. Chat with a support agent for more information

NEW

Thank you for choosing MyCoursebay. Your presence is a motivation to us. All papers are written from scratch. Plagiarism is not tolerated. Order now for a 15% discount

Order Now