DBMS Flashcards
Give an Example of flat file data base
Ms excel
Give an example of relational database
SQL, oracle, mysql
tables are the ________ of a data base
building blocks
tables store the complete matter in the structure of ______ and _______
rows and columns
all columns in a table are called _______
fields
all the tables in a row are called ______
records
a record consists of all the _______ that belong to a single person
fields
what is data
a set of characters that represents valid value is called data
to retrieve the _______ data from a data base queries are used
unfiltered
queries are also used to perform actions such as _______ , ________, ETC
DELETING UPDATING
forms provide a _________ that facilitates the procsess of _________ in tables and queries
interface-friendly, entering data
reports are used to _________ the data in a ________
display , printable format
reports collect the _________ data from one or ore _________
summarized, tables or queries
full form of DBMS
data base management system
Full form of RDBMS
Rational database management system
a relation database allows the prevention of a _________ in the data
duplication
where is the title bar located
at the top of the window
what does the title bar display
the name of the current database
where is the quick access toolbar located
top left