The Most Rapid Essay Writing Service For Your Academic Success

Become a better student and get high grades with our professional writers.

Welcome to the #1 paper writing service, where each essay writer knows your needs and saves you from endless tasks!

  • We cover all disciplines and academic styles.
  • We meet your deadlines and formatting requirements.
  • We ask nothing but your “thank you” in return.

Entrust our essay writing service with your homework today—and forget about dull tasks and poor grades forever.

scenario 3

The Scenario:
You have been hired by a manufacturing company with multiple manufacturing facilities to perform the logical design of a 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:
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.
The Deliverable:
In a Microsoft Word document provide a complete integrated set ofnormalized (3NF required)relations using the format displayed in Figure 9.3e on page 316 (note that entities are in all caps attribute names with multiple words are connected by an underline character joining each word (for example Student_ID) primary keys are underlined and listed first within the attributes) in Third Normal Form (see pages 318-321 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)
There are multiple problems here: multiple students could have the same last name course name might occur many times within the table and could be entered incorrectly or misspelled in some records instructor name might occur many times within the table and could be entered incorrectly or misspelled in some records semester name might occur many times within the table and could be entered incorrectly or misspelled in some records.
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_IDCourse_IDInstructor_IDSemester_ID)

You can leave a response, or trackback from your own site.
Powered by WordPress | Designed by: Premium WordPress Themes | Thanks to Themes Gallery, Bromoney and Wordpress Themes