Purchase Solution

Relational Data Model (case 2)

Not what you're looking for?

Ask Custom Question

Install DB2 Express-C, create the SAMPLE database, and validate your installation, following the detailed installation instructions in Chapter 3 of the DB2 book. Write a short paper describing the following:

Your experience with the installation.
Open the Control Center and the SAMPLE database, make screen shots of the database and copy them into your paper;
Open the SAMPLE database and its Tables folder, describe what information you see there, using the terms introduced in this module, such as table, schema and key. Describe the EMPLOYEE and EMP_PHOTO tables in detail.

Purchase this Solution
Solution Summary

The solution discusses the Relational Data Model for a case.

Solution Preview

See the attached file.

Subject Category: Computer Science / Computing and Communications Software
Date of Response: 09/01/2011
Keywords: Database, Installation, IBM DB2, DB2 Express-C, SAMPLE Database, Install Validation, db2level, Database Administration

Page Title: Installing DB2 Express-C and Validate Install

Solution Abstract: The goal of this solution is to show the student how the install process behaves in relation to Vendor Instructions and the resolution pathways they should take to validate and diagnose Install related issues. The solution also shows the student what the DB2 Control center should look like and how some of the information is organized in the Control Center's views.

Description: The solution is comprised of a Microsoft Word document The document 421855Express-C Install.docx is attached.

Attachment Description: Microsoft Word 2007 document 421855Express-C Install.docx. In line solution also contains step by step explanation.

Brief Description:
Install DB2 Express-C, create the SAMPLE database, and validate your installation, following the detailed installation instructions in Chapter 3 of the DB2 book.

Full Problem Description:
Relational Data Model (case 2)
Install DB2 Express-C, create the SAMPLE database, and validate your installation, following the detailed installation instructions in Chapter 3 of the DB2 book. Write a short paper describing the following:

Your experience with the installation.
Open the Control Center and the SAMPLE database, make screen shots of the database and copy them into your paper;
Open the SAMPLE database and its Tables folder, describe what information you see there, using the terms introduced in this module, such as table, schema and key. Describe the EMPLOYEE and EMP_PHOTO tables in detail.
Solution Description:

Experience with the installation:
The download and the install ran smoothly as expected after watching the video: http://www.channeldb2.com/video/video/show?id=807741:Video:4442
and also the Install Video:
"Lunch with DB2" Series Installation 1: http://www.channeldb2.com/video/video/show?id=807741%3AVideo%3A2562

To make sure that the install proceeds as planned make sure that the system login has Administrative privileges.
The install runs like any other install with approving the license agreement, selecting an install type typical, limited, custom [selected typical], then moves to a unique option set:
a) Install exp C on this computer
b) Save my installation settings in a response file - No software will be installed on this computer
c) Install DB2 Express C on this computer and save my settings ina response file

[Selected option c)] Reponse file name: C:usersmyUserDocumentsPROD_EXPC.rsp
The install then opens dialog to select which folder. [Selected the default option C:Program FilesIBMSQLLIB
Then the install asks for setup on the user information for the DB2 Administration Server. The DB2 Admin Server (DAS) runs on your computer to provide support required by the DB2 tools. Specify the required user information for the DAS. It is highly recommended that you use a local user or a domain user account instead of the LocalSystem account. Further details are available by clicking Help.
[Selected Local User - No Domain - Username: xxxxxxxxxxxx9999 pwd: xxxxx999xxxxx
Next dialog configures the instances, select default by clicking Next
Next dialog is Configure DB2 instance authority groups. Local is preselected with the authority group name already assigned: instauthgroup0
Click Next
Next dialog Start copying files and create response file lists the current settings and features as follows:
Product to install: DB2 Express-C - DB2COPY1
Installation type: ...

Purchase this Solution
Free BrainMass Quizzes
Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.

C# variables and classes

This quiz contains questions about C# classes and variables.

Javscript Basics

Quiz on basics of javascript programming language.

Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.

Inserting and deleting in a linked list

This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.

View More Free Quizzes
Related BrainMass Solutions

  • Significance of RDF

    239160 Significance of RDF What are the various reasons that make RDF data model essential to store data, rather than using xml or relational model? Include references. Why RDF?

  • When to Use a Relational Database Model

    542872 When to Use a Relational Database Model 1. When would you use a relational database model? 2. What makes up a database system? 1. .

  • OLAP versus RDBMS

    Studies show that the Multidimensional database (OLAP): - Uses almost half the disk space of what Relational database requires for the same task, - Retrieves data between 8 and 200 times faster, and - Calculates the derived data at least 2 orders

  • Database Traits Relational

    This tired ensure that same type system as application program. 3.Flat model: This is not a exactly a data model.This has 1 or 2 dimensional array of data elements. 4.Hierarchical model: This like a tree-like structure .A single record upward

  • Relational data model

    Define the relational data model and, given a problem description and a representation of the associated database, determine if the database satisfies the properties of a relational database Here is the relational data model: (please see the attached

  • Structured Query Language - an important tool

    The relational model was the first formal database model. The Relational Model itself is based on well developed set theory which includes well defined operations on data sets.

  • Database design process

    Relational database model: It is a digital database whose organization is based on the relational model of data.

  • Hierarchical database

    218646 Hierarchical database Demonstrate your understanding of a hierarchical database, network database, relational database, and object-oriented database Hierarchical Database: A hierarchical data model is a data model in which the data is organized

  • Object oriented database versus Relational database

    Solution: The relational database model is not doomed to extinction, but will only be used by certain smaller companies and specialized industries because of the time needed to break complex information into usable data.

  • Normalization within Database

    "Further Normalization of the Data Base Relational Model." (Presented at Courant Computer Science Symposia Series 6, "Data Base Systems," New York City, May 24th-25th, 1971.) IBM Research Report RJ909 (August 31st, 1971). Republished in Randall J.

View More Related Solutions