RelationalDBDesign
SiteMap
Database Architecture
Database Admin
Managing Users
Managing Objects
Backup Recovery
Admin Tasks
Managing Constraints
«Prev
Next»
Managing Objects
Space Management
Storage Management Concepts
Data Blocks
Data System Blocks
Segment Role
Oracle extents Data
Extent Allocation
Setting Extent Size
Tablespace Default
Data Dictionary Storage
Oracle Free Space
Oracle Lists
Space Blocks
Free Space
Table Space Fragmentation
Tablespace Database Objects
Correct Table Space
Coalesce Tablespace
Space Management Conclusion
Managing Tables
Schema Manager Table
Managing Constraints
Four Basic Constraints
Primary Key Constraints
Database Table Constraints
Create Foreign Constraints
Unique Foreign Key Constraints
Table Trigger
Adding Table Constraints
Implement Column Constraints
Data Dictionary Constraints
Managing Constraints
Oracle Indexes
Oracle Database Index
Oracle Data Index
Index Types
Create Table Index
Separate Indexes-
Alter Index Attributes
Rebuilding Oracle Index
Data Dictionary Views
Drop Index Oracle
Using Oracle Indexes
Managing Privileges
Granting Privileges
Grant Command
Using Security Manager
Listing Table Privileges
Listing Privileges Columns
Revoking Object Privileges
Object Privileges Conclusion
Database Security Roles
Database Roles
Creating Roles
Granting Role Privileges
Default non Default Roles
Password Protected Roles
WITH ADMIN OPTION
Securit yGranted By Roles
Invoker Caller Routine
View Information about Roles
Listing Granted Roles
Drop Database Role
PRIMARY KEY Constraints - Exercise
Course project: Using primary Key Constraints
Objective:
Create primary key constraints for the
COIN
database
<3>Exercise scoring
This exercise is worth a total of 24 points. Each completed block of code is worth 4 points. You will be graded on completeness and correctness of code. When you complete your answer, submit your answer.
Background and Overview
Earlier in this course, you created a script file with the SQL statements needed to create the tables in your
COIN
database. In this exercise, you will modify those scripts to include primary key constraints.
Download files
You can download a correct version of the script for this exercise, primarykey.sql, from the project download file found on the Resources page.
Instructions
Add a primary key constraint for each table in the
COIN
database.
Hints
You can create a primary key that includes multiple columns by listing the columns, separated by commas.
Submitting your exercise
Submit your answer in the text box below.
