Docsity
Docsity
Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity

Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan

Guidelines and tips
Guidelines and tips
Sell on Docsity
Sell on Docsity
Docsity AI
Docsity AI
Log inSign up

Prepare for your exams

Study with the several resources on Docsity

Find documents

Prepare for your exams with the study notes shared by other students like you on Docsity

Search for your university

Find the specific documents for your university's exams

Docsity AINEW

Summarize your documents, ask them questions, convert them into quizzes and concept maps

Explore questions

Clear up your doubts by reading the answers to questions asked by your fellow students

Earn points to download

Earn points by helping other students or get them with a premium plan

Share documents
download point icon20 Points

For each uploaded document

Answer questions
download point icon5 Points

For each given answer (max 1 per day)

All the ways to get free points
Get points immediately

Choose a premium plan with all the points you need

Study Opportunities

Choose your next study program

Get in touch with the best universities in the world. Search through thousands of universities and official partners

Community

Ask the community

Ask the community for help and clear up your study doubts

Free resources

Our save-the-student-ebooks!

Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors

Database Fundamentals: Terms and Definitions, Quizzes of Information Technology

Louisiana State University (LSU) - System OfficeInformation Technology

Definitions for various terms related to databases, including database, user data, metadata, table, record, field, data modeling, entity, instance, attribute, identifier, primary key, null, entity integrity constraint, select, from, where, order by, aggregate functions, and sql queries.

Typology: Quizzes

2017/2018

Uploaded on 02/02/2018

awarde3
awarde3 🇺🇸

4.5

(2)

96 documents

1 / 14

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
TERM 1
A collection of related files
DEFINITION 1
Database
TERM 2
Logically related data stored in a single
logical data repository
DEFINITION 2
Database
TERM 3
A self-describing collection of data
DEFINITION 3
Database
User Data
Metadata
TERM 4
(a data file)
DEFINITION 4
table
TERM 5
a unit/thing of interest; aka Record
DEFINITION 5
Table Rows
pf3
pf4
pf5
pf8
pf9
pfa
pfd
pfe

Partial preview of the text

Download Database Fundamentals: Terms and Definitions and more Quizzes Information Technology in PDF only on Docsity!

A collection of related files

Database

TERM 2

Logically related data stored in a single

logical data repository

DEFINITION 2

Database

TERM 3

A self-describing collection of data

DEFINITION 3

Database

User Data

Metadata

TERM 4

(a data file)

DEFINITION 4

table

TERM 5

a unit/thing of interest; aka Record

DEFINITION 5

Table Rows

n attribute of the units ; aka Field

Table Column

TERM 7

The technique for creating the logical

structure of a database

DEFINITION 7

Data Modeling

TERM 8

A database must mirror the real world if it is

to answer questions about the real world

DEFINITION 8

Modeling reality

TERM 9

is a design technique for capturing

reality

DEFINITION 9

Data modeling

TERM 10

is a distinct object (a person, place, thing,

concept, or event) in the organization that is

to be presented in the dataset

DEFINITION 10

entity

can be created if there is no obvious attribute

An identifier

TERM 17

becomes a table

DEFINITION 17

entity

TERM 18

becomes the table name

DEFINITION 18

entity name

TERM 19

becomes a column

DEFINITION 19

attribute

TERM 20

becomes the primary key

DEFINITION 20

identifier

attribute or a minimum set of attributes that

can identify uniquely rows within a table.

primary key

TERM 22

must be enclosed in single quotes:

DEFINITION 22

All non-numeric literals

TERM 23

literals must not be enclosed in quotes:

DEFINITION 23

All numeric

TERM 24

Represents value for an attribute that is

currently unknown or not applicable for tuple

DEFINITION 24

Null

TERM 25

Deals with incomplete or exceptional data

DEFINITION 25

Null

Specifies the order of the output

ORDER BY

TERM 32

Get all firms with a price-earnings ratio less

than 12

DEFINITION 32

SELECT * FROM share WHERE shrpe < 12;

TERM 33

Get all firms with a price-earnings ratio less

than 12.

DEFINITION 33

SELECT * FROM share WHERE shrpe < 12;

TERM 34

List the firms name, price, quantity, and

dividend where share holding is at least

DEFINITION 34

SELECT shrfirm, shrprice, shrqty, shrdiv FROM share WHERE

shrqty >= 100000;

TERM 35

Find all firms where the PE is 12 or higher and

the share holding is less than 10,000.

DEFINITION 35

SELECT * FROM share WHERE shrpe >= 12 AND shrqty <

Report firms whose code is AR.

SELECT * FROM share WHERE shrcode = 'AR';

TERM 37

Report firms with a dividend of 2.50.

DEFINITION 37

SELECT * FROM share WHERE shrdiv = 2.5;

TERM 38

n List details of all offices where the state has

not been recorded.

DEFINITION 38

SELECT * FROM offices where state is NULL;

TERM 39

Used with a list of

values

DEFINITION 39

IN

TERM 40

Report data on firms with codes of FC, AR, or

SLG.

DEFINITION 40

SELECT * FROM share WHERE shrcode IN

('FC','AR','SLG');orSELECT * FROM share WHERE shrcode =

'FC' ORshrcode = 'AR' OR shrcode = 'SLG';

Find the average

dividend.

SELECT AVG(shrdiv) AS avgdiv FROM share;

TERM 47

What is the average yield for the

portfolio?

DEFINITION 47

SELECT AVG(shrdiv/shrprice*100) AS avgyield FROM share;

TERM 48

counts all rows

DEFINITION 48

COUNT(*)

TERM 49

counts rows with non null values for

columname

DEFINITION 49

COUNT(columname)

TERM 50

Find the number of firms in the

portfolio.

DEFINITION 50

SELECT COUNT(shrcode) AS investmentsFROM share;

A query within a query

Subqueries

TERM 52

List all firms containing Ruby in their

name.

DEFINITION 52

SELECT shrfirm FROM shareWHERE shrfirm REGEXP 'Ruby';

TERM 53

Search for a string

DEFINITION 53

Regular expression

TERM 54

Search for alternative strings

DEFINITION 54

Regular expression

TERM 55

List the firms containing gold or zinc in their

name

DEFINITION 55

SELECT * FROM shareWHERE shrfirmREGEXP

'gold|zinc|Gold|Zinc';

is the alternation

symbol

TERM 62

Eliminating duplicate rows when reporting

DEFINITION 62

DISTINCT

TERM 63

Report the different values of the PE ratio.

DEFINITION 63

SELECT shrpe FROM share;SELECT DISTINCT shrpe FROM

share;

TERM 64

Delete existing records in a table

DEFINITION 64

DELETE

TERM 65

Modify the existing records in a tbale

DEFINITION 65

UPDATE

Erase the data for Burmese Elephant. All the

shares have been sold

DELETE FROM shareWHERE shrfirm = 'Burmese Elephant';

TERM 67

Change the share price of FC to 31.50.

DEFINITION 67

UPDATE shareSET shrprice = 31.50WHERE shrcode = 'FC';

TERM 68

Increase the total number of shares for

Nigerian Geese by 10% because of the recent

bonus issue

DEFINITION 68

UPDATE shareSET shrqty = shrqty*1.1WHERE shrfirm =

'Nigerian Geese';