Purchase Solution

SQL DDL and DML Queries

Not what you're looking for?

Ask Custom Question

Hi,

See attached file for assignment problems.

Thank you

DDL and DML

1. For emp table, set the constraint that Hiredate is later than Jan. 1, 1980.

2. Modify Dept table so that dname column can contain up to 20 characters.

3. Define ProdId+StartDate as the primary key for Price table.

4. Insert this row of data into price table:

Prodid= 200380, stdprice =5, minprice =4.4, startDate =today, EndDate =null.

5. Delete the row added in the previous step from Price table using Delete from (not rollback).

Q18-Q20 require using data dictionary items. Use one SQL for each.
18. Find all check constraints defined on emp. In the result, list name of the constraint.)
19. Find all tables in your account. Return the table names as output.
20. Find all foreign key constraints defined on emp table and on dept table. In the list, list the name of the constraint and which table it is defined on. USE only one SQL statement to accomplish this.)

Attachments
Purchase this Solution
Solution Summary

This solution deals with a set of eight DDL and DML queries. Most of the queries are based on basic DDL and DML commands.

Purchase this Solution
Free BrainMass Quizzes
C++ Operators

This quiz tests a student's knowledge about C++ operators.

Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.

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: Table of Contents

Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.

Basic Networking Questions

This quiz consists of some basic networking questions.

View More Free Quizzes
Related BrainMass Solutions

  • Kudler Fine Foods- Complete Database SQL Queries

    256954 This question deals with a set of SQL queries based on the Kudler Fine Foods Virtual Case. This includes a set of SQL DDL commands as well as DML commands.

  • data manipulation capabilities

    DDL Triggers SQL Server 2005 has extended traditional triggers and enabled them to be fired for DDL operations like CREATE, ALTER, and DROP.

  • data definition languages

    Once the database structure is defined via DDL, database administrators and users use another SQL sublanguage DML to insert, retrieve or modify the data contained with the DBMS.

  • SQL Queries

    Cheers Rao This solution deals with a set of 5 SQL queries based on DDL and DML statements

  • Setting up business rules in database layer

    The above business rules can be setup in the database layer using the DDL, DML and DCL commands. The DDL is the data definition language using which one can create the database schema and structures.

  • SQL DDL and DML Queries

    You'll need to use multiple DML statements. Define the following primary keys and foreign keys for these two tables. Use multiple DDL statements for this. Think carefully about the sequence of SQL statements used here.

  • Creating Tables Using SQL Server

    Update the data in the Employees table so that employees with the following managers are listed as working in the following departments: ReportsTo Department Andrew Fuller Sales Steven Buchanan Marketing All Others CEO Submit the SQL, DDL, and DML

  • features and uses of SQL

    We must pecify the size Dates-----DATE SQL has three flavors of statements. The DDL, DML and DCL. DDL is Data Definition Language statements.

  • SQL Statement

    This solution consists of questions on SQL queries mainly DML statements and select statement.

View More Related Solutions