Sam Kemei, Activity 6
5.Write SQL commands for the following:
a. Create two different forms of the INSERT command to add a student with a student ID of 65798 and
last name Lopez to the Student table.
INSERT INTO Student (StudentID, StudentName) VALUES (65
Unit 2: Activity Problems
Chapter 1, Review Questions #2.
b database application
m data warehouse
j user view
k database management system
h data independence
i enterprise resource plann
Data Administration and Database Administration
Database administration and data administration fall under the general category of data management.
Data management, as has been historically defined as an in-depth and comprehensive understanding
Number is an integer (such as 1 or 2) that distinguishes one
section from another for the same course but does not uniquely identify a
section. I modeled SECTION as generally as possible, using a many-tomany relationship with semester. This wa
Persistent and Non-Persistent IT Systems
Data structure persistence is defined as a data structure that stores all the previous states of the data
structure before a new change occurs. In a fully persistent (Driscoll, 1989) IT data repository, c
Data Warehouse Solutions for Stock Exchanges
The best examples I found of online publicly accessible data warehouses are stock exchange data
warehouses. Real time trade data from hundreds if not thousands of stock brokerage outlets and
Student: Sam Kemei
Here is the database which I used for my web project Online Sports Store.
Database name: Products.
Here are the fields:
ProductID: int, not null, primary key identity
Name: varchar(100), not null
Description: varchar(500), not null