{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}


Cummins_DatabaseDesignExercise - Em p PK Emp First N Emp...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
DATABASE DESIGN EXERCISE Project1 1.  Create, using Normalization techniques, all of the levels for the master table below. Change # PK Chang e Time Chang e Desc Chang e Type Change Commen ts PC System Employ ee Approv er Employe e Perform er Chang e Severi ty Change Complexi ty Compa ny Locatio n PC OS Compa ny Busines s Chang e Status 2.  Create a metadata spec sheet defining the table above.  Take educated guesses, or ask during project  check-up times, about values that may not be ultimately clear.  Hint:  Complexity could be a A or N value,  depending on how the system is designed. Project 2 1.  Create, using Normalization techniques, all of the levels for the master table below.
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Em p # PK Emp First N Emp LastN Addy Stre et Add y City Addy Zip Tele Home # Tele Mobile # Tele MMS Compa ny Dept Compan y Business Emp Years Emp Spous e Emp Mgr Emp Edu Emp Degre e 2. Create a metadata spec sheet defining the table above. Take educated guesses, or ask during project check-up times, about values that may not be ultimately clear. Hint: Complexity could be a A or N value, depending on how the system is designed....
View Full Document

{[ snackBarMessage ]}