Busy. Please wait.

show password
Forgot Password?

Don't have an account?  Sign up 

Username is available taken
show password


Make sure to remember your password. If you forget it there is no way for StudyStack to send you a reset link. You would need to create a new account.
We do not share your email address with others. It is only used to allow you to reset your password. For details read our Privacy Policy and Terms of Service.

Already a StudyStack user? Log In

Reset Password
Enter the associated with your account, and we'll email you a link to reset your password.

Remove Ads
Don't know
remaining cards
To flip the current card, click it or press the Spacebar key.  To move the current card to one of the three colored boxes, click on the box.  You may also press the UP ARROW key to move the card to the "Know" box, the DOWN ARROW key to move the card to the "Don't know" box, or the RIGHT ARROW key to move the card to the Remaining box.  You may also click on the card displayed in any of the three boxes to bring that card back to the center.

Pass complete!

"Know" box contains:
Time elapsed:
restart all cards

Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.

  Normal Size     Small Size show me how

Focal QA-Chapter 15

Chapter 15 - Database Testing

What does DBMS mean? Database Management System
What is DBMS used for? Used for storage of data and efficient retrieval of data
What is a database? An organized collection of data
What does a database do? It is a container storing data that people or devices can interact with. data is stored in a structured way, by creating tables.
What does not impose any constraints or security? DBMS
What does RDBMS mean? Relational Database Management System
What is RDBMS used for? Data are stored in a relation or table. Each table contains rows or records, (also called tuples), and Columns which represent attributes or fields. Each record or row is represented by a unique field known as the Primary key. Small database 2GB.
What does SQL mean? Structured Query Language
Rows - a.k.a. Records , tupple
Columns - a.k.a. fields , attribute
1NF - First Normal Form No repeating groups, all tables are two-dimensional
2NF - Second Normal Form No repeating groups, all tables are two-dimensional. Plus each data element is identified by one corresponding unique identifier-a primary key- that is not a composite and therefore cannot be subdivided into smaller bits of data.
3NF - Third Normal Form Plus all tables contain no data other than that which describes the intent of the primary key - extraneous data is placed in separate tables.
Records - a.k.a. Rows , tupple
Tupple - a.k.a. Rows , records
fields - a.k.a. columns , attribute
attribute - a.k.a. fields , columns
Database application computer program whose primary purpose is entering and retrieving information from a computer-managed database
Created by: 194307150