Em Andamento

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

Habilidades: Engenharia, MySQL, Oracle, PHP, Arquitetura de software, Teste de Software

Ver mais: 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\, grading, gpa, data source sql, cmis, describe courses

Acerca do Empregador:
( 10 comentários ) United States

ID do Projeto: #2976592

Premiar a:

ibcodervw

See private message.

$2 USD em 5 dias
(1 Comentário)
0.0

13 freelancers estão ofertando em média $18 para este trabalho

mocak2

See private message.

$34 USD in 5 dias
(41 Comentários)
5.4
edifus

See private message.

$8.5 USD in 5 dias
(28 Comentários)
5.0
gopikap

See private message.

$8.5 USD in 5 dias
(54 Comentários)
5.1
ziran

See private message.

$25.5 USD in 5 dias
(47 Comentários)
4.5
compsyseng

See private message.

$12.75 USD in 5 dias
(27 Comentários)
4.1
shashikhanvw

See private message.

$59.5 USD in 5 dias
(15 Comentários)
3.8
oradevvw

See private message.

$17 USD in 5 dias
(7 Comentários)
2.2
eugeneturin

See private message.

$12.75 USD in 5 dias
(6 Comentários)
2.7
vlad2005dev

See private message.

$8.5 USD in 5 dias
(3 Comentários)
1.3
jainvipin

See private message.

$25.5 USD in 5 dias
(0 Comentários)
0.0
darlk

See private message.

$17 USD in 5 dias
(1 Comentário)
0.0
madhavshankar

See private message.

$8.5 USD in 5 dias
(0 Comentários)
0.0