Create a table names students with the fields

Assignment Help Basic Computer Science
Reference no: EM131446231

1.) Create a table names STUDENTS with the following fields (all fields are required unless specified. Do not change the field names, data types or data sizes - follow directions as specified below):

StudentId - autonumber - unique id/primary key

StudentFirstName - text(20)

StudentMiddleName - text(20-not required)

StudentLastName - text(30)

BirthDate - date

Major - text(50)

Minor - text(50-not required)

CertificateProgram - text(50-not required)

ClassLevel - Freshman, Sophomore, Junior, Senior, Graduate

GPA - decimal number with 3 decimal points between 0 & 4.000 (for example 3. 456)

SemesterHoursCompleted - number between 0 & 180

AdmissionDate - date

GraduationDate - date (not required)

2.) Create at least 5 records in the STUDENTS table created above. All values must be meaningful and within the data type and range as specified in the table.

Do not put this in a Microsoft Access spread sheet.

Reference no: EM131446231

Questions Cloud

Evaluating resources in business and technology : This is your opportunity to examine the current research and begin to identify gaps that may suggest new topic areas for further research. This assignment is designed to help you explore and critically analyze research literature that will support..
Explain your interpretation of what occurred in the dialogue : A process recording is a written tool used by field education experience students, field instructors, and faculty to examine the dynamics of social work interactions in time. Process recordings can help in developing and refining interviewing and ..
Program features include asking the user : The program features include asking the user for the number of test scores; creating an array to hold the scores; creating a Marker object passing the scores array as a parameter; displaying the lowest score; adjusting the mean by annulling (dropp..
Describe the activities that you will use : Summarize the key information, ideas, theories that your project relies on. Describe the activities that you will use and how you plan to lead these.
Create a table names students with the fields : 1.) Create a table names STUDENTS with the following fields (all fields are required unless specified. Do not change the field names, data types or data sizes - follow directions as specified below):
Create a document that includes a transcript of a call : Create a document that includes a transcript of a call from the patient's point of view based on the information in the case study including basic personal information and reasons for seeking out psychotherapy. The call may be no more than 5 minut..
Develop your rfp for a project : As an IT consultant, you will need to be very familiar with RFPs and understand what organizations expect from your bid proposals. To understand the perspective of the requesting organization, you will develop an RFP and submit it to one of your f..
Details all the steps of visualization : Explain in details all the steps of visualization. List the visualization methods andexplain which one is used on which type of data and when.
Research designs that include selecting participants : Research designs that include selecting participants from identified subgroups within the total population employ

Reviews

Write a Review

Basic Computer Science Questions & Answers

  Identifies the cost of computer

identifies the cost of computer components to configure a computer system (including all peripheral devices where needed) for use in one of the following four situations:

  Input devices

Compare how the gestures data is generated and represented for interpretation in each of the following input devices. In your comparison, consider the data formats (radio waves, electrical signal, sound, etc.), device drivers, operating systems suppo..

  Cores on computer systems

Assignment : Cores on Computer Systems:  Differentiate between multiprocessor systems and many-core systems in terms of power efficiency, cost benefit analysis, instructions processing efficiency, and packaging form factors.

  Prepare an annual budget in an excel spreadsheet

Prepare working solutions in Excel that will manage the annual budget

  Write a research paper in relation to a software design

Research paper in relation to a Software Design related topic

  Describe the forest, domain, ou, and trust configuration

Describe the forest, domain, OU, and trust configuration for Bluesky. Include a chart or diagram of the current configuration. Currently Bluesky has a single domain and default OU structure.

  Construct a truth table for the boolean expression

Construct a truth table for the Boolean expressions ABC + A'B'C' ABC + AB'C' + A'B'C' A(BC' + B'C)

  Evaluate the cost of materials

Evaluate the cost of materials

  The marie simulator

Depending on how comfortable you are with using the MARIE simulator after reading

  What is the main advantage of using master pages

What is the main advantage of using master pages. Explain the purpose and advantage of using styles.

  Describe the three fundamental models of distributed systems

Explain the two approaches to packet delivery by the network layer in Distributed Systems. Describe the three fundamental models of Distributed Systems

  Distinguish between caching and buffering

Distinguish between caching and buffering The failure model defines the ways in which failure may occur in order to provide an understanding of the effects of failure. Give one type of failure with a brief description of the failure

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd