Share
Explore BrainMass

Student Information Table

See the attached file.

1) Your task is to first "sketch" a Student Information table (basically what columns should be included in the table) using the Student_information table at the following as example. Your table should contain the following:

Column heading include all the attributes that need to be in this table.
Populate the table with 10 records of data
You can use the Student_information table as an example, add or remove attributes based on your analysis.

2) Sketch a course information table using the following table as an example. Feel free to add or remove attributes based on your analysis. Your table should contain the following:

Column heading include all the attributes that need to be in this table.
Populate the table with 10 records of data. (tip: use course catalogue for more course numbers and titles)

3) Use an ER diagram to represent the data modeling.

4) Write a one page discussion on problems you have encountered in this assignment and what issues you might find in this design.

5) Create the table you have just designed in DB2 without using SQL statement. Take a screen shot of the tables and paste them to the document.

Attachments

Solution Preview

I left the Student information table pretty much the same but ...

Solution Summary

The solution assists with sketching a student information table.

$2.19