Purchase Solution

Writing Code in SQL

Not what you're looking for?

Ask Custom Question

Download, unzip, and attach the sample database ITD640_A from the link below. The sample database represents an educational institution with students and different schools. Each student goes to just one school. The students have various roles in different assignments and may work on more than one assignment at a time. zip file is attached.

Using the sample database, write the scripts in a file called ITD640_P3.SQL to create the following views. Remember to include a USES clause at the top of the script file to use the ITD640_A database. Also include code that checks if the view already exists. If it does, it should be dropped and recreated.

Create a view named v_worker showing the student number, assignment number, and start date where the role is "worker."
Create a view called v_no_points with all the columns of the assignment table except the points column.
Create a view called v_count that shows the number of students working on each assignment. The view should have columns for the assignment number and the count.

Attachments
Purchase this Solution
Solution Summary

This solution involves a code written in SQL.

Purchase this Solution
Free BrainMass Quizzes
Basic UNIX commands

Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.

Word 2010: Tables

Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.

Javscript Basics

Quiz on basics of javascript programming language.

Inserting and deleting in a linked list

This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.

Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.

View More Free Quizzes
Related BrainMass Solutions

  • SQL Queries Exercise

    Although you don't need to build any tables with data, it would help to do this so you can test your sql query. In order to better understand sql you need to practice writing sql. Hello, I have attached the solution.

  • Write SQL Statements

    (b) Explain the dangers of the sequence of statements in part (a) above, in terms of what would happen in case the database server or SQL interface were to crash in between two of these three statements.

  • SQL Query: Student Information

    Query5 Write a SQL statement to display the First and Last Name of students who live in the Zip code 88888 or 88808. Do not use IN.

  • Methods that can be used to graphically create SQL queries

    All types of SQL statements can be parsed and run in the Query Builder dialog box. " In my opinion, as a professional SQL developer with ten years' experience, written code presents the most flexibility.

  • SQL Command Code

    240688 SQL Command Code CREATE TABLE contacts (Con_id NUMBER(4), Company_name VARCHAR2(30) not null, E_mail VARCHAR2(30), Last_date DATE DEFAULT SYSDATE, Con_cnt NUMBER(3) CHECK (Con_cnt > 0), PRIMARY KEY (Con_id)); 1.

  • SQL Query Statements

    Query3 Write a SQL statement to display the First and Last Name of students who live in the Zip code 88888. Query4 Write a SQL statement to display the First and Last Name of students who live in the Zip code 88888 and have the major of Biology.

  • Using a semicolon (;) in MS Access

    And finally, in order to use the ";" in the query (searching for a string with a ";" in it) you need to use " around it. SELECT * FROM employees WHERE name = ";" In SQL a semicolon (;) is intended to end a SQL statement.

  • PHP Code: Databases

    599873 Php code Some tips about using php code to - Add a new item to the database - Delete an existing item from the database, Note: need some help on how to use PHP code to add and delete item from database.

  • Software Information Assurance

    The direct method of preventing SQL injection from affecting your data is to use dynamically generated SQL in the users code.

View More Related Solutions