Sql joins and typical query usagecreate the following

Assignment Help Management Information Sys

Reference no: EM13357842

SQL Joins and Typical Query Usage.

Create the following queries on the ITCO630_A database used in unit 3 and save them all in a file called ITCO630_P5.SQL. Please note that you can execute individual queries in a query file by highlighting the lines that you want to execute before running the script. Remember to define what database to use with a USE statement.

1. Using a join, get the full details of all the students who work on the mid-term exam assignment.
2. Get the assignment names (duplicates eliminated) being worked on by students at Central University.
3. Get the last names of all the students who are working on assignment A1.
4. Get the student numbers and start dates of all the students with start dates equal to the earliest date.
5. Insert yourself into the student table using the last five digits of your phone number as the student number and show yourself as attending Central University. Then show all the records in the student table.
6. Delete yourself from the student table by matching your student number, and then show all the records in the student table.

You should create a zip file called ITCO630_P5.ZIP with your query file (ITCO630_P5.SQL) included.

- Communicate with a relational database to create tables, and query and manipulate data.
- Use normalizing and data integrity methodologies when designing a database.
- Create and manage databases and their related components.

Reference no: EM13357842

Questions Cloud

Discussing technology implementationdetail how a new : discussing technology implementationdetail how a new technology system should be implemented or introduced to a

Implementation methods of information systems : implementation methods of information systems conversionexplain the four implementation methods parallel plunge pilot

How changing technology is shaping businessjust like many : how changing technology is shaping businessjust like many other areas of business organizational change has been

Management of information systems and itinformation systems : management of information systems and itinformation systems are typically thought of as being the responsibility and

Sql joins and typical query usagecreate the following : sql joins and typical query usage.create the following queries on the itco630a database used in unit 3 and save them

Subquery vs joinwhich is better to use a subquery or a join : subquery vs. join.which is better to use a subquery or a join? why?show an example of each to support your

It success metricsit success metrics also known as : it success metricsit success metrics also known as benchmarks are critical to business. this discussion challenges you

Preferred operating systemssome people believe that the : preferred operating systemssome people believe that the only reason that the microsoft windows operating system is so

Technology advancements and written business : technology advancements and written business correspondencetechnology has made the process of communication both easier

User Account

All Pages