Lab_02_AM08 - 7.104 DATABASE ENGINEERING I WEEK 02 AM8 LAB...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
7.104 DATABASE ENGINEERING I WEEK 02 – AM8 LAB CREATE DATABASES & TABLES, INSERT DATA & SELECT DATA This laboratory exercise aims for the student to familiarize with constructing SQL Query (SELECT Statement) in SQL Server and Oracle Database Systems. A simple instruction will be issued to students to show how to create two database objects (DB_7104 and DB_ username ) follows by executing SQL scripts to create tables and populate with requited data. It is recommended for students to follow these steps; (A)Login into the PC with the appropriate account (am8-? / ?) 1. Copy the folder WVPC_7104_2 from drive K into Desktop. 2. Copy the folder DB_7104 from the network drive into the Desktop of your virtual machine XPVM_7104 (Use USB pen-drive) (B) Create two database systems – DB_7104 and DB_ username in SQL Server 2008 and Oracle 11g and execute the required SQL scripts to create the tables and populate with data. SQL Server 2008
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 3

Lab_02_AM08 - 7.104 DATABASE ENGINEERING I WEEK 02 AM8 LAB...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online