DATABASE MODELING AND ER DIAGRAM

 

Developing a Database System for ABC University Students

 

In this assignment, you will start to create a database using OpenOffice Base without writing any SQL statement.

 

Project Description

 

You are hired by ABC University IT department. Your first assignment is to work on a database project to store student information and track their progress in their coursework (what courses students have taken and their scores etc). Eventually your database should be able to generate the following report:

 

Students who live in California

 

Students who live outside California

 

Names of students who take ITM440 course

 

Names of students who live in California and take ITM440 course

 

Student names, courses they have taken, and letter grade for each of these courses

 

Any other information you would like to retrieve from the database

 

By Module 4, your database should accomplish all the tasks above. In this assignment however, you are required to work on only part of it.

 

Assignment Overview

 

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 example, add or remove attributes based on your analysis.

 

Student_information

 

Student ID	Name	Phone	E-Mail	Street number	Street name	City	State
0001	John	408‑452‑6241	[email protected]	1100	Pine	Sacramento	CA
0002	Mary	714‑452‑0211	mary&yahoo.com	45	Rose	San Diego	CA
0003	Jason	562‑890‑2233	[email protected]	6780	Winchester	San Jose	CA
0005	Lily	650‑123‑8000	[email protected]	2340	El Camino	Albany	KY
0006	Matt	312‑567‑4560	[email protected]	211	Campbell	Bowling green	OH
0007	David	650‑338‑9910	[email protected]	5122	Peach	Jackson	MS
0008	Jason	310‑456‑6790	[email protected]	4590	Moody	Occasion side	CA

 

Sketch a course information table using the following table as 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

 

Use ER diagram to represent the data modeling.

 

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

 

Create table you have just designed iin OpenOffice Base without using SQL statement. Take a screen shot of the tables and paste them to the document.

 

SLP Assignment Expectations

 

You are evaluated based on whether the tables have been created correctly and your demonstrated effort.

 

Clear explanation of your express with this assignment

 

Do you want your assignment written by the best essay experts? Order now, for an amazing discount.