Describe information using table

Assignment Help Database Management System
Reference no: EM1356174

Using IBM DB2 Express-C open the Control Center and the SAMPLE database, make screen shots of the database. Open the SAMPLE database and its Tables folder, describe the information seen, using the terms such as table, schema and key. Describe the EMPLOYEE and EMP_PHOTO tables in detail.

Reference no: EM1356174

Questions Cloud

Proactive and reactive crisis management : Proactive and Reactive Crisis Management - Why should an organization be concerned with both proactive and reactive crisis management?
Identify and explain the five strategies that contribute : Identify and explain the five strategies that contribute to a successful small business and How does each strategy provide for successful results
Steps in accounting cycle and items on balance sheet : What are the steps of the accounting cycle? Why is it necessary to make adjusting entries at the end of each accounting period? What would happen if all of the steps of the accounting cycle were not completed in a specific accounting period?
Global expansion through franchising for market penetration : The CEO is looking for another country in which to enter with his restaurant. He has to work within certain limitations, etc. One my suggestions will be to establish more franchises within the countries where restaurants were recently opened.
Describe information using table : Describe the information seen, using the terms such as table, schema and key. Describe the EMPLOYEE and EMP_PHOTO tables in detail.
Major categories of tests : List the major categories of tests, giving one example for each category. When giving your example, list the users of the test and a use for the test.
Determining pension worksheet-journal entries : Using the above information for ABC co., prepare a pension work sheet for 2008. Indicate (credit) entries by parentheses. Calculated amounts should be supported. Prepare the journal entries to reflect the accounting for the company's pension plan f..
Global risk factors : Explain what factors are most prevalent in today's market and how can one modify investment strategies to account for such risks?
Describe the equilibrium price and sales : Describe the equilibrium price and sales of X. Let PY = $10. Determine whether X and Y are substitutes or complements.

Reviews

Write a Review

Database Management System Questions & Answers

  Prepare the relational schema for database

Prepare the relational schema for database

  Application important part of security model for databases

Using Internet as the research tool for extra information not presented in text, describe why application roles are important part of the security model for databases.

  Explaining controls for database to execute transaction

Controls which need a database to either execute transaction completely or not at all.

  Create application owner and stored in schema

One of the tenets of database development is to never permit developers to create or own objects during development. All objects are created by application owner and stored in that schema.

  Same name to attributes which are in different tables

What about giving same name to attributes which are in different tables but are not same? For instance, "Description" in both a Course table and a Classroom table.

  Design a set of 3nf tables for database scenario

Draw an ER diagram for your database scenario. Design a set of 3NF tables for your database scenario.

  Recognize business processes evaluated-dw-bi application

Identify the business processes which would be evaluated and tracked with a DW/BI application and state your reasoning or justification for including these in the DW/BI.

  Explaining unclustered b pus tree index

Suppose you have a table which contains 27,000 data records, and you have unclustered B+ Tree Index on the table.

  Role and tasks performed by database administrator

In 250 - 300 words describe role of a database administrator and the tasks performed by this role. Also, describe why this role is important in Database Management.

  Draw an entity relationship diagram for the system

Draw an Entity Relationship diagram for the system and Identify the table design for the database displaying all the fields/attributes. Ensure that all tables are in 3NF. You also need to identify the primary keys and foreign keys, where applicable..

  Explain the datawarehouse and data mining concepts

There are six major types of information systems which organisations use in their operations. Discuss how these information systems support managers in their decision making role Explain the datawarehouse and data mining concepts using appropria..

  Explain primary problem in credit card records

You have a file which contains credit card records. Each record contains field for the card number, expiration date, and name of card holder. Explain what primary problem you try to solve is.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd