Purchase Solution

Student Information Table

Not what you're looking for?

Ask Custom Question

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
Purchase this Solution
Solution Summary

The solution assists with sketching a student information table.

Solution Preview

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

Purchase this Solution
Free BrainMass Quizzes
Basic Networking Questions

This quiz consists of some basic networking questions.

Javscript Basics

Quiz on basics of javascript programming language.

Word 2010: Table of Contents

Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.

Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.

C# variables and classes

This quiz contains questions about C# classes and variables.

View More Free Quizzes
Related BrainMass Solutions

  • Keeping Info about students and tutors

    . /* Add new columns to Student table */ ALTER TABLE Student ADD [Name] VARCHAR(30) NOT NULL, [Address] VARCHAR(50) NULL, [Phone] VARCHAR(12) NULL, [Email] VARCHAR(20) NULL /* Add new columns to Tutor table */ ALTER TABLE Tutor

  • Creating a university grade system on Microsoft access.

    Information Math Student Info Table: Student ID (Automatically Generated sequential number) FirstName (12 character text field) MiddleInitial (1 character text field) LastName (15 character text field) Phone (Use appropriate mask) Socsec (Use

  • Real world examples of relational database types

    Second, we have information on students, such as student id, student name, student dorm and student phone, which can be stored in an entity called STUDENT.

  • Normalisation of Database Design

    250 Williams 4 ITM452 Client Server System Administration 250 Williams 4 ITM541 Network Administration and Operations 312 Johnson 4 PA501 Introduction to Public Administration 225 McVey 4 Student Table: Student Information Student ID Name Phone

  • database concept

    Consider a student table containing a student's number, student's name, student's major department, student advisor's number, student advisor's name, student advisor's office number, student advisor's phone number, student's number of credits, and student's

  • C++ Generate a Report for Summarizing Student Scores and Avg

    The first row has the information about the size of the table. The first item on the first row is the number or rows in the table, and the second item represents the number of columns in the table.

  • Web Application Development - Visual Studio.Net

    Userid and password is validated against table "tblLogin" .Once user is authenticated and is redirected to page "default.aspx". Page "default.aspx" has list of student information.

  • Write a SQL query that returns the names of the students

    ";"Popyack";"Mathematics" 7;"Kurt";"Schmidt";"Mathematics" 8;"Jason";"Lenhart";"Mathematics" ;"";"";"" Table SQL: -- student information CREATE TABLE Student ( id SERIAL PRIMARY KEY, -- student id number fname VARCHAR(20

  • Oracle Sqlplus

    The information about the STUDENT table is provided below. When creating the table, make sure to include appropriate constraints defined in the description. (see table in attachment) 2. Write an SQL code to create the VENDOR table.

View More Related Solutions