Purchase Solution

Adding Primary Key to Tables

Not what you're looking for?

Ask Custom Question

7. Add a PRIMARY KEY constraint to the CH10DOG table. The primary key column is named DOG_ID. The constraint should be nondeferrable, immediate, and enable. Include the parameters for the constraint states even though they are the default settings and not technically required. Save the SQL.

Attachments
Purchase this Solution
Solution Summary

This posting contains SQL statement for adding primary key to table CH10DOG.

Purchase this Solution
Free BrainMass Quizzes
C# variables and classes

This quiz contains questions about C# classes and variables.

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.

Basic Networking Questions

This quiz consists of some basic networking questions.

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.

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.

View More Free Quizzes
Related BrainMass Solutions

  • Simple Relationship Diagrams: ER diagrams

    Table definitions for the table structures and primary keys constraints are shown below. You will need to identify the FOREIGN KEY(s) to complete this problem.

  • Relational data model

    The primary keys and foreign keys well defined. This data base can be extended for adding more tables.

  • Database Construction Using Access

    STEP 6 Add at least two rows of data to each table in your database. Use any values you like for each of the columns. Remember that you must add data to parent tables before adding data to child tables, because referential integrity is enabled.

  • SQL Server 2000

    Create tables in the database you created including adding columns (fields) of an appropriate data type to the table and designating a primary key. Create at least 3 - 4 tables with what you feel are appropriate columns and data types.

  • functional dependencies

    Convert this table to an equivalent collection of tables that are in third normal form.

  • Master-Detail Relationship

    One table has Primary key(s) and the next detail table has the Foreign key(s). If you Filter the Primary key then the detail must be filter out against that Foreign key in the Table.

  • Process of Joining Tables Together with Primary Keys

    Sometimes we have to select data from two or more tables to make our result complete. We have to perform a join. Tables in a database can be related to each other with keys. A primary key is a column with a unique value for each row.

  • Designing a database for university

    tables with multiple field primary key.

  • Identification of keys and entity relationship model

    FIGURE Q3.12 The Ch03_Theater Database Tables Answer:- a) The Primary keys for the table DIRECTOR would be DIR_NUM The Primary key for the table PLAY would be PLAY_CODE b) The foreign Key for PLAY table is DIR_NUM which in-turn is the Primary

View More Related Solutions