Tutorial Week 4
Step by Step
1. Open the client application for your RDBMS and connect to the INVENTORY database.
2. For the following steps, make sure you already complete your previous tutorial exercise
(Create table, create view, insert records, etc.).
1.Open the client application for your RDBMS and connect to the INVENTORY database.
2Create CD_ARTISTS table with the following fields: ARTIST_ID INT, ARTIST_NAME
VARCHAR (60), AGENCY_ID (INT)
In this tutorial, you will use the data modification statements to modify data in the INVENTORY
database. You will use the INSERT statement to add data, the UPDATE statement to modify
data, and the DELETE statement to remove
Week 5 Tutorials
Create an ER model for each of the following descriptions:
a) A large organization has several parking lots, which are used by staff.
b) Each parking lot has a unique name, location, capacity, and number of floors.
c) Each parking lot has
The importance of database system.
Some common uses of database systems.
and the Web
In this chapter you will learn:
The meaning of the client-server architecture and the
advantages of this type of architecture for a DBMS.
The difference between two-tier, three-tier client-