DBMS- Exam 1 2023 with 100% correct answers

descriptive attributes attributes describing an entity relationship cardinality describes the number of entities in one entity set that can be associated with the number of entities in another set domain a range of values that can be assigned to an attribute (varchar, number, 10, 20) simple attribute atomic composite attribute can be split into multiple atomic attributes in a tree-like form (name-- first name, last name) multi-value attribute example email address single-value attribute example social security number derived attribute example age (from DOB) 11 characteristics a database should have -organized -shared -permanent or persistant -validity/integrity/correctness -security -consistency -non-redundancy -independent -easy access -recoverable -flexible to change characteristics of a relational database -values are atomic -each row stands alone -sequence of rows is insignificant -each column has a column name object-oriented database stores objects such as pictures, graphs, and videos computer architecture a set of rules and methods that describe the functionality, organization and implementation of computer systems centralized database located, stored and maintained in one location decentralized database can reside on an organized network of servers on the internet or on an intranet or extranet 1 tier architecture only one entity where the user may sit on the DBMS and directly use it 2 tier client/server -DBMS can be accessed on multiple client computers -must have an application