Create a table with a primary key to identify business

Assignment Help Software Engineering

Reference no: EM1378964

Create the following tables for a "University Grade System".

Courses
Majors
Student Info
Courses Taken

Courses Table:

Course (This is the key and is a six letter text field)
Advisor (This is a required 40 letter text field)
Extension (This is a required four digit extension field)

Put the following data into the table
MTH100 Robert Rubenstein 1375
CSS200 Suzy Simpson 1476
BUS101 Ed Espinoza 1567
SOC404 Fred Fong 1577

Majors Table:
Create a table with a primary key to identify the following majors:
Business
Computer 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 appropriate mask for social security number)
Major (Must already be in "Majors" table to be accepted)
Birthdate (Use appropriate mask for date)
Year in School (FR, SO, JR, SR)

Courses Taken Table;

Construct a table that will store data about each student that took a course and what grade they received. The information should include the semester of completion.

Create an input form with appropriate form controls for each of the tables listed above (four) and put in at least ten records in the Student Info Table and at least twenty records in the Courses Taken table.

Purchase Solution
$2.19 Add to Cart

Reference no: EM1378964

Questions Cloud

Pseudocode for a recursive function : Think about a language of words, where each word is a string of dots and dashes. The following grammar describes this language:

Debugging facilities for art of programming : The BlueJ development environment offers simple but sufficient debugging facilities for those new to and learning the art of programming.

Determine one number missing from the sequence : Certain major software corporation likes to use in their interviews. Like many algorithm design problems, there are many possible answers, but I have presented one of the more generally accepted ones.

Implement the finite field gf : Write a program called "GF2.java" to implement the finite field GF(p n )where p is a prime number andn is a positive integer.You also need to write four methodsto realize.

Create a table with a primary key to identify business : Construct a table that will store data about each student that took a course and what grade they received. The data should include the semester of completion.

Identify the data type for variable : Assume you manage a dog walking service, in which you interact with both clients and dog walkers. Your task is to schedule dog-walking appointments based on the customers requested dates and times and the availability of the dog walkers.

Tcp sender and receiver sequence : Think about a TCP sender and receiver. Suppose bytes 0 .. 99 have been sent, received, and acknowledged (the sender has received ack's for them). Suppose the sender sends the following segments

Explanations on spreadsheet concepts : A workbook can contain more than one worksheet. Provide an example of a spreadsheet application where it would be necessary to have more than one worksheet, can you describe how that works?

Optimize a schedule of events and reduce lost productivity : Apply Scheduling Theory in order to optimize a schedule of events and reduce lost productivity

User Account

All Pages