The assignment is to create views in the ITCO630_A database using SQL scripts. Three views need to be created: v_worker, which shows student number, assignment number, and start date where the role is 'worker'; v_no_points, which has all columns of the assignment table except points; and v_count, which shows the count of students working on each assignment.

ITCO630_P3: Create views in ITCO630_A database, including v_worker, v_no_points, and v_count, to display student-assignment data.

Creating Views in ITCO630_A Database

The assignment consists of four parts: Part 1, where students are required to create a database called ITCO630_P1.MDF and add tables with specific data; Part 2, which involves designing a single table to store invoice information and applying normalization to reduce the table to third normal form; Part 3, where students must download, unzip, and attach the sample database ITCO630_A, then create views based on that database; and Part 4, which requires students to write queries using the ITCO630_A database.

Database Operations and Design

Project

For this group project, students will create a database system to solve a business problem of their choice. The database system must meet specific requirements, including creating at least three related tables, two stored procedures, one view, one trigger, and five useful queries that use subqueries and aggregate functions. Each student will also prepare an individual summary document with a Word description, ERD representation, step-by-step query instructions, and a summary of strengths and weaknesses of the system.

Group Database System Design

The assignment is an introduction to MySQL, where students import and query a sample employee database. The goal is to perform various SQL operations on the database and submit the resulting output as a tarball containing four files: queries.txt, new_hires.csv, high_salaries.csv, and high_salary_names.csv. Students will create three queries to recognize newest employees, create views for high salary employees and names, and redirect their outputs to respective CSV files.

Databases

Introduction to MySQL Queries

This assignment requires creating SQL queries to manipulate data in the ITCO630_A database used in Unit 3. The tasks include using joins to retrieve student details, getting unique assignment names at Central University, retrieving last names of students working on a specific assignment, identifying students with earliest start dates, inserting and then deleting a self-record in the student table.

Database Queries for ITCO630 P5

This document explains the process of creating a database for Desklib, an online library for study material. It covers the use of MySQL, the creation of tables with primary and foreign key constraints, the use of triggers, views, and select queries for reporting purposes.

London South Bank University

Database Creation for Desklib

The assignment requires creating a series of Excel macros, pivot tables, and UserForms, as well as generating an Access database and query report. The tasks involve data cleaning, filtering, plotting, and reporting in Excel, and querying and linking data between Excel and Access.

Creating Views in ITCO630_A Database

End of preview

Database Operations and Design

Group Database System Design

Introduction to MySQL Queries

Database Queries for ITCO630 P5

Database Creation for Desklib

Excel and Access Tasks

Creating Views in ITCO630_A Database

End of preview

Database Operations and Designlg...

Group Database System Designlg...

Introduction to MySQL Querieslg...

Database Queries for ITCO630 P5lg...

Database Creation for Deskliblg...

Excel and Access Taskslg...

Database Operations and Design

Group Database System Design

Introduction to MySQL Queries

Database Queries for ITCO630 P5

Database Creation for Desklib

Excel and Access Tasks