De La Salle Lipa
COMPUTER S 123
// because it will only be used by one person,
// db app is if you have multiple users
Dbms
// this is answerable by either dbms or db, but if you're talking about actual data, it's db
Database
CONCEPT EXAM
Monday, December 2, 2024 9:17 AM
CCINFOM Page 1
//database management system creates the file operations and execut
...[Show More]
// because it will only be used by one person,
// db app is if you have multiple users
Dbms
// this is answerable by either dbms or db, but if you're talking about actual data, it's db
Database
CONCEPT EXAM
Monday, December 2, 2024 9:17 AM
CCINFOM Page 1
//database management system creates the file operations and executes that
//only the application that the end users interact with
// type 3 is relating records to each other
// type 2 is mathematical processing and updating and deletion of data
// lots of activities in db management
CCINFOM Page 2
// false
// because part of datamanagement is creating records, and it's possible that the db is initially empty and it's possible to create new records
//making an sql statement
//data manipulation is part of db management
// focusing on what data will be digitized, "what data involved"
//deciding whether it'll be included or digitized is component of data
CCINFOM Page 3
// does not include what procedures to be involved
//dbms is a software
//not process because not how it's produced
//only talking about how reports appear and how data is stored -- data component of the environment
// devices -- hardware
CCINFOM Page 4
//sys analyst - gathers requirements
//db designer - translates it
//db to be "implemented" - not yet implemented means still needs to be implemented, this happens during design
//forward engineer is the db admin, but in some cases nagmimix yung db developer, but formally it's db admin
CCINFOM Page 5
// db operator does the reports
// no additional
// internal physical, logical (external)
// physical view is the internal structure, and only dbms knows that, dbms maps it, not the designer
CCINFOM Page 6
//physical views are internal views, and only the dbms understands that, so dbms maps it
// true -- always conceptual representations
//no addtl comment
//when you are going to provide info on user to make decision, that's always the characteristic of relevant
CCINFOM Page 7
// you want your formula to be as accurate as possible
// accuracy - more associated with the computations and detail of the numbers that appear
//not verifyability
//reliability - moving out of keyboard entries because we want the data to be captured more reliably
//keyword: can immediately see
//not really relevant BUT if you remove the "immediately see" then it's relevant
CCINFOM Page 8
//keyword: check: verifiability
//if you're talking about overwhelmed then that's violation of simplicity
Note: views are a misnomer (we don't know what "views" refer to), are database views the same as representation -- the answer is true
Sa data information, what's the main distinguish for simple vs presentable
If you're talking about aesthetics -- presentable
▪ "how the data looks like"
○
Effect on data on the user -- simplicity
▪ Ex: overwhelm, confused…
○
Reliable vs secure
Reliable - making sure that the collection of the data will be reliable
▪ Always the COLLECTION part
▪ Usually replacing a data entry part with another
•
Secure
▪ Accessing? Forgot what he said mbmb
•
Coverage…
CCINFOM Page 9
Coverage…
- Model
- Some concepts in sql dml dcl
- Select clauses from clauses group by clauses
- Db design concepts
CCINFOM Page 10
[Show Less]
