Communicate with a relational database

Assignment Help Management Information Sys

Reference no: EM1323999

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: EM1323999

Questions Cloud

Ethnocentrism and culturally diverse groups : What is ethnocentrism? How does it affect perceptions among culturally diverse groups? Explain in at least 200 words. Please describes the concept of ethnocentrism and how it influences perceptions among culturally diverse groups.

Management of information systems : Management of information systems and IT management of information systems should be the sole responsibility of IT or if other areas should have a role. Describe the reasoning behind your conclusion

Explain non-traditional approaches to retirement : Explain Non-traditional Approaches to Retirement and post a summary of your overall position on this topic and list some of the key points you want to make

Accessing gaps and hr roles : Propose your response as if you were the HR Director of a large multinational company. Give ample thought to what your role as the company's top HR person might be; how your time should be divided and how you might best use the talents of subordin..

Communicate with a relational database : SQL Joins and Typical Query Usage - Communicate with a relational database to create tables, and query and manipulate data.

Introduction to psychotherapy : How do defferent minority groups differ in terms of their views of mental illness and psychotherapy?

Explain viability and desirability of conducting market : Explain Viability and desirability of conducting market research and Discuss views about the viability and desirability of conducting market research when establishing a revolutionary new e-business

Manage databases and their related components : Subquery vs. Join. - Create and manage databases and their related components.

Discuss your business success metrics : IT Success Metrics - compare and discuss your business success metrics

User Account

All Pages