Explore BrainMass
Share

Explore BrainMass

    Relational Data Model (case 2)

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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.

    © BrainMass Inc. brainmass.com October 10, 2019, 3:29 am ad1c9bdddf
    https://brainmass.com/computer-science/user-interface/relational-data-model-case-421855

    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: ...

    Solution Summary

    The solution discusses the Relational Data Model for a case.

    $2.19