Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

COSC 304 > Database intro > Flashcards

Database intro Flashcards

1
Q

Database

A

Collection of logically related data for a particular domain

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Database management system

A

Software designed for the creation and management of databases

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Data definition language language

A

Allows the user to create data structures in the data model used by the database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Schema

A

Description of the structure of the database and is maintained and stored in the system catalog. The schema is metadata

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

DDL vs DML

A

DDL allows user to create data structures in the data model used by the database whereas DML gives the user access to the data once the database has been created using DDL

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Data model

A

Collection of concepts that is used to describe the structure of a database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly

COSC 304 (10 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions