DATABASE ASSIGNMENT 6
6.2 Explain how database administration tasks vary with the size and complexity of the database.
Database come in a variety of sizes and scopes, from single user personal database to huge
interorganizational database. All database ha
7.4 What is a trigger, and how is it used?
A trigger is a program attached to a specific table or view within a database and executed by the DBMS
when specific events occur using that table or view. A special type of stored procedure that is
Assignment 5 Review questions
4.2 What is a data model, and what is its purpose?
A representation of the content, relationships, and constraints of the data needed to support the
database requirements. A Data Model is a way to organize the data that you h
Banking Database for Saving and Checking Accounts
Wells Fargo is the third largest bank in the U.S. by assets and the largest bank by market
capitalization. And the second largest bank in deposits, home mortgage servi
Structured Query Language
Pronounced as S-Q-L [Ess-Que-El]
Originally developed by IBM as the SEQUEL language in the 1970s
SQL-92 is an ANSI national standard adopted in 1992.
SQL:2011 is current standard.
SQL is not a programming language,