Flashcards › Database Management

Database A collection of information that is organized so that it can easily be accessed, manage, and updated. Table A single store of related information. It consists of records, and each record is made up of a number of fields. Entity A single person, place or thing about which data can be stored. Tuple One row or record in a database. Attributes Data items that describe an entity. Primary Key A field that uniquely identifies a record in a table. Composite Key A primary key that is made up of more than one attribute. Candidate Key One that identify each row of a table uniquely. Alternate/Secondary Key Any candidate key which is not selected to be the primary key. Foreign Key A key used in one table to represent the value of a primary key in a related table. Data type this determines the type of data that a field can store Text stores alphanumeric characters(letters and numbers) up to 255 Number stores numbers with or without decimal places Date/Time stores date/time type values Currency stores money values Autonumber stores automatic numbers such as an ID number Memo stores blocks of text like notes up to 65536 characters long Yes/No stores a yes or no value Database terms as well as advantages and disadvantages.