EMILLYCHARLOTTE 2024/2025 ACADEMIC YAER
©2024 EMILLYCHARLOTTE. ALL RIGHTS RESERVED
FIRST PUBLISH SEPTEMBER 2024
ISQS Delgadillo Exam 3 TTU Study
Guide with Complete Solutions
Data Resource Management - Answer✔✔--when you use technology to mange data.
Database Administrator (DBA) - Answer✔✔--Responsible for managing the data,
work with programmers and systems analyst to design and implement database.
-Also work with users and managers of the firm to establish policies for managing.
Why is there a demand for more and better data? - Answer✔✔--competitive
environment.
-powerful workstations that can handle data quickly.
-more computer literate personnel.
Equivalent of DBMS : Office - Answer✔✔-Database: file cabinet
File: file drawer
Record: file folder
Record Attributes: Report
Hierarchy of data - Answer✔✔--Database
-Files
-Records
-Attributes
-Characters
-Bits
1/16
,EMILLYCHARLOTTE 2024/2025 ACADEMIC YAER
©2024 EMILLYCHARLOTTE. ALL RIGHTS RESERVED
FIRST PUBLISH SEPTEMBER 2024
Database - Answer✔✔--Integrated collection of logically related data elements.
-Personnel File, Payroll File, Department File
File - Answer✔✔--(e.g. personnel file)
◦ 098-40-1370 Clooney, George 1-20-2010
◦ 594-39-3948 Kidman, Nicole 3-24-2009
◦ 234-34-3483 Hanks, Tom 2-02-2009
◦ 457-74-3854 Winslet, Kate 1-23-2009
Record - Answer✔✔--(Record containing SSN, Last and
First name, Hire date)
-594-41-3955 Bullock, Sandra 4-24-07
Attribute - Answer✔✔--(last name)
◦ Bullock
-Characters (bytes)
◦ 01100010 (Letter "B" in Binary Code)
Bits - Answer✔✔-- 0 or 1
flat file - Answer✔✔--A table storing all database information in one large two-
dimensional table.
Traditional approach disadvantages - Answer✔✔-- you have to change your address
at every place where everyone has their own file on you.
-Data are stored, organized and processed in independent files
-Data duplication- everyone has your address.
2/16
, EMILLYCHARLOTTE 2024/2025 ACADEMIC YAER
©2024 EMILLYCHARLOTTE. ALL RIGHTS RESERVED
FIRST PUBLISH SEPTEMBER 2024
-Lack of integration- its impossible to combine two different databases or files.
-data dependence- when you change files you have to change program.
Database approach - Answer✔✔--when you need to change an address now just
change it on raider link. Its from one central location.
-files are consolidated into a common pool of records available to many different
application programs.
-requires the use of a database management system.
advantages of database approach - Answer✔✔--minimal data redundancy (data
duplication minimized)
data integration
-program-data independence (no data dependence)
hierarchal model - Answer✔✔-• data is organized in a top-down (inverted tree)
structure.
• Parent - child relationships
• one-to-many relationship (one parent, many children)
-problem with it is a parent can have many children but a child only has one parent.
(One to many relationship)
-One access path- one path to top and bottom element.
Network model - Answer✔✔--an extension of the hierarchical model.
-owner - member relationships
-Many to many relationships.
-a member may have several owners
3/16
©2024 EMILLYCHARLOTTE. ALL RIGHTS RESERVED
FIRST PUBLISH SEPTEMBER 2024
ISQS Delgadillo Exam 3 TTU Study
Guide with Complete Solutions
Data Resource Management - Answer✔✔--when you use technology to mange data.
Database Administrator (DBA) - Answer✔✔--Responsible for managing the data,
work with programmers and systems analyst to design and implement database.
-Also work with users and managers of the firm to establish policies for managing.
Why is there a demand for more and better data? - Answer✔✔--competitive
environment.
-powerful workstations that can handle data quickly.
-more computer literate personnel.
Equivalent of DBMS : Office - Answer✔✔-Database: file cabinet
File: file drawer
Record: file folder
Record Attributes: Report
Hierarchy of data - Answer✔✔--Database
-Files
-Records
-Attributes
-Characters
-Bits
1/16
,EMILLYCHARLOTTE 2024/2025 ACADEMIC YAER
©2024 EMILLYCHARLOTTE. ALL RIGHTS RESERVED
FIRST PUBLISH SEPTEMBER 2024
Database - Answer✔✔--Integrated collection of logically related data elements.
-Personnel File, Payroll File, Department File
File - Answer✔✔--(e.g. personnel file)
◦ 098-40-1370 Clooney, George 1-20-2010
◦ 594-39-3948 Kidman, Nicole 3-24-2009
◦ 234-34-3483 Hanks, Tom 2-02-2009
◦ 457-74-3854 Winslet, Kate 1-23-2009
Record - Answer✔✔--(Record containing SSN, Last and
First name, Hire date)
-594-41-3955 Bullock, Sandra 4-24-07
Attribute - Answer✔✔--(last name)
◦ Bullock
-Characters (bytes)
◦ 01100010 (Letter "B" in Binary Code)
Bits - Answer✔✔-- 0 or 1
flat file - Answer✔✔--A table storing all database information in one large two-
dimensional table.
Traditional approach disadvantages - Answer✔✔-- you have to change your address
at every place where everyone has their own file on you.
-Data are stored, organized and processed in independent files
-Data duplication- everyone has your address.
2/16
, EMILLYCHARLOTTE 2024/2025 ACADEMIC YAER
©2024 EMILLYCHARLOTTE. ALL RIGHTS RESERVED
FIRST PUBLISH SEPTEMBER 2024
-Lack of integration- its impossible to combine two different databases or files.
-data dependence- when you change files you have to change program.
Database approach - Answer✔✔--when you need to change an address now just
change it on raider link. Its from one central location.
-files are consolidated into a common pool of records available to many different
application programs.
-requires the use of a database management system.
advantages of database approach - Answer✔✔--minimal data redundancy (data
duplication minimized)
data integration
-program-data independence (no data dependence)
hierarchal model - Answer✔✔-• data is organized in a top-down (inverted tree)
structure.
• Parent - child relationships
• one-to-many relationship (one parent, many children)
-problem with it is a parent can have many children but a child only has one parent.
(One to many relationship)
-One access path- one path to top and bottom element.
Network model - Answer✔✔--an extension of the hierarchical model.
-owner - member relationships
-Many to many relationships.
-a member may have several owners
3/16
