XYZ State College $-$ Part $2$

Using the work completed and corrected from the XYZ State College $-$ Part $1,$ complete the

following exercises:

User Views

You have just interviewed the Dean of the Business and Applied

Technologies School to determine their database needs.

For each view below:

i$.$ Determine and list the changes that would need to be

completed to provide the Dean this capability.

ii$.$ Include any assumptions your take in your decision$-$making

process. Note: If a natural key does not exist in the example

data, you will need to create an artificial key.

iii. List all tables in $3^{rd}$ normal form in DBDL format including

all keys.

Note: Make sure you include items $1-3$ above for each

problem $($view$)$ below $(1,2,3$a$,3$b$).$ Failure to include these

items will make it very difficult for me to grade your work

and it will adversely impact your grade. If you have

questions, please ask.

The Dean informs you that they rely on a several key reports that

need to be generated to help them monitor activities and make

decisions. Note: In the analysis of these user views, you will need

to determine what changes $($if any. need to be made to the basic

database structure developed in Part $1.$

One of the key decisions to be made, is the determination of

whether a given section will run based upon student

enrollment. In order to make this decision, the Dean requires a

report listing students registered by section. You are given a

sample report with the following data items: StudentID, First

Name, Last Name $($CourseNum$,$ Description, Department,

Credit Hours, SectionNum, GradeEarned$).$