Terminé

SQL statements homework help

The tables are attached in separate file!

Use the DESCRIBE command to display the data types of the columns after each table is created.

Use the ALTER TABLE statement to define the StudentID as the PRIMARY KEY for the STUDENTS table.

Use the ALTER TABLE statement to define the StudentID and CourseNumber as the PRIMARY KEY for the COURSES table.

Use the ALTER TABLE statement to define StudentID in the COURSES table as a FOREIGN KEY that references the StudentID in the STUDENTS table. Use the USER_ tables and display the following metadata:

List the tables in the presently in the schema

List the Indexes

List the Views

For the STUDENT and COURSES tables, display the columns in each table, their data types and whether or not they allow NULL values

For the STUDENT and COURSES tables, display constraints on each table For each student, count the number of courses he or she has taken.

Modify the above query to only count CMIS courses.

Add .05 to all of the CMIS major's GPA's ??" the instructor has been grading too strictly!

Change Sam's tutor from Sue to Jane

For any student who is currently majoring in CMIS and who has a GPA of less than 3.0, change their major to Marketing ??" they need an easier option!

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.

**I need all the statements to execute the above queries!**

## Platform

Windows

Oracle

Compétences : Ingénierie, MySQL, Oracle, PHP, Architecture Logicielle, Tests de Logiciels

en voir plus : sql to oracle, sql code oracle, package sql oracle, oracle sql package, need an engineering student, need a marketing tutor, need a marketing students help, sql marketing, sql less than, oracle sql number, c++ homework help, tutor sql, sue, statements, sql views, php tutor, oracle queries, marketing tutor, Jane, homework help\

Concernant l'employeur :
( 10 commentaires ) United States

Nº du projet : #2976592

Décerné à:

ibcodervw

See private message.

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 5 jours
(1 Évaluation)
0.0

13 freelance font une offre moyenne de $18 pour ce travail

mocak2

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(41 Commentaires)
5.4
edifus

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(28 Commentaires)
5.0
gopikap

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(54 Commentaires)
5.1
ziran

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(47 Commentaires)
4.5
compsyseng

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(27 Commentaires)
4.1
shashikhanvw

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(15 Commentaires)
3.8
oradevvw

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(7 Commentaires)
2.2
eugeneturin

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(6 Commentaires)
2.7
vlad2005dev

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(3 Commentaires)
1.3
jainvipin

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(0 Commentaires)
0.0
darlk

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(1 Évaluation)
0.0
madhavshankar

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(0 Commentaires)
0.0