Solution-Use an er diagram to represent the data modeling.

Use an er diagram to represent the data modeling.

Assignment Help Database Management System

Reference no: EM13949023

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	[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

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.

Reference no: EM13949023

Questions Cloud

Cyclical type of business-reflected in dividend policy : ACME is a very cyclical type of business which is reflected in its dividend policy. The firm pays a $2.00 a share dividend every other year. The last dividend was paid last year. Five years from now, the company is repurchasing all of the outstanding..

Calculating flotation costs : The Dunning Co. needs to raise $66.9 million to finance its expansion into new markets. The company will sell new shares of equity via a general cash offering to raise the needed funds. The offer price is $69 per share and the company’s underwriters ..

Discuss a story from an objective stance : Short Story "book" reports are informative reports that discuss a story from an objective stance. They are similar to reviews but half of the paper is a summary of the work and the other half is an evaluation of it. Short story "book" reports desc..

Net present value of this project given your sales forecasts : Your firm is considering a project with a five-year life and an initial cost of $130,000. The discount rate for the project is 12%. The firm expects to sell 2,100 units a year. The cash flow per unit is $20. What is the net present value of this proj..

Use an er diagram to represent the data modeling. : Sketch a course information table using the following table as an example. Feel free to add or remove attributes based on your analysis

Discounting-reinvestment and combination approach : The company uses a 9 percent interest rate on all of its projects. What is the MIRR of the project using the reinvestment approach? The discounting approach? The combination approach?

Angular velocity at instant : The 10-lb bar is pinned at its center O and connected to a torsional spring. The spring has a stiffness k = 5 lb # ft>rad, so that the torque developed is M = (5u) lb # ft, where u is in radians. If the bar is rele..

Discuss how ideas about how wellness and well-being have : Discuss how ideas about how wellness and well-being have developed as presented in the literature used in your module readings, as well as the modules themselves.Identify five concerns and discuss one concern that these issues raise in your mind, tha..

Calculate the annual incremental operating cash flows : Calculate the annual incremental operating cash flows for the new machine. Calculate the terminal value of the new machine.

User Account

All Pages

Use an er diagram to represent the data modeling.

Reference no: EM13949023

Reference no: EM13949023

Questions Cloud

Reviews

Write a Review

Database Management System Questions & Answers

Knowledge and data warehousing

Design a database schema

Entity-relationship diagram

Implement a database of courses and students for a school

Prepare the e-r diagram for the movie database

Design relation schemas for the entire database

Prepare the relational schema for database

Data modeling and normalization

Use cases perform a requirements analysis for the case study

Knowledge and data warehousing

Stack and queue data structure

Practice on topic of normalization

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT