Use the Student_information table in the following as an 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.
Student_information
|
Student ID
|
Name
|
Phone
|
Email
|
Street number
|
Street name
|
City
|
State
|
|
0001
|
John
|
408-452-6241
|
john@hotmail.com
|
1100
|
Pine
|
Sacramento
|
CA
|
|
0002
|
Mary
|
714-452-0211
|
mary&yahoo.com
|
45
|
Rose
|
San Diego
|
CA
|
|
0003
|
Jason
|
562-890-2233
|
Jason@gmail.com
|
6780
|
Winchester
|
San Jose
|
CA
|
|
0005
|
Lily
|
650-123-8000
|
lily@sbcglobal.com
|
2340
|
El Camino
|
Albany
|
KY
|
|
0006
|
Matt
|
312-567-4560
|
matt@att.com
|
211
|
Campbell
|
Bowling green
|
OH
|
|
0007
|
David
|
650-338-9910
|
david@hotmail.com
|
5122
|
Peach
|
Jackson
|
MS
|
|
0008
|
Jason
|
310-456-6790
|
Jason@yahoo.com
|
4590
|
Moody
|
Occasion side
|
CA
|
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)
Course_information
|
Course ID
|
Title
|
credit
|
|
ITM432
|
Principles of Finance and Financial Information Systems
|
4
|
|
ITM433
|
Computer-Human Interaction, Groupware, and Usability
|
4
|
|
ITM434
|
Business Ethics and Social Issues in Computing
|
4
|
|
ITM435
|
Marketing and Marketing Information Systems
|
4
|
|
ITM436
|
Operations Management and Operations Information Systems
|
4
|
|
ITM440
|
Database Technology and Database Administration
|
4
|
|
ITM441
|
Network Technology and Network Administration
|
4
|
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.