ISQS Delgadillo Exam 3 TTU Questions And Answers Latest Updates
4 keer bekeken 0 keer verkocht
Vak
ISQS Delgadillo TTU
Instelling
ISQS Delgadillo TTU
Database Administrator (DBA) - ️️-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.
File - ️️-(e.g. personnel file)
◦ Clooney, George 1-20-2...
Database Administrator (DBA) - ✔️✔️-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.
File - ✔️✔️-(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
Why is there a demand for more and better data? - ✔️✔️-competitive environment.
-powerful workstations that can handle data quickly.
-more computer literate personnel.
Data Resource Management - ✔️✔️-when you use technology to mange data.
Equivalent of DBMS : Office - ✔️✔️Database: file cabinet
File: file drawer
Record: file folder
Record Attributes: Report
Hierarchy of data - ✔️✔️-Database
-Files
-Records
-Attributes
-Characters
-Bits
Database - ✔️✔️-Integrated collection of logically related data elements.
-Personnel File, Payroll File, Department File
Record - ✔️✔️-(Record containing SSN, Last and
First name, Hire date)
-594-41-3955 Bullock, Sandra 4-24-07
flat file - ✔️✔️-A table storing all database information in one large two-dimensional
table.
Traditional approach disadvantages - ✔️✔️- 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.
-Lack of integration- its impossible to combine two different databases or files.
-data dependence- when you change files you have to change program.
advantages of database approach - ✔️✔️-minimal data redundancy (data duplication
minimized)
data integration
-program-data independence (no data dependence)
hierarchal model - ✔️✔️• 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 - ✔️✔️-an extension of the hierarchical model.
-owner - member relationships
-Many to many relationships.
-a member may have several owners
-more than one path of access
-one major problem was once relationships were set it was very difficult to break them.
Relational model - ✔️✔️-most inefficient, but it's the most friendly.
-represented with tables.
-You connect the tables on common data elements. (Look at online notes)
-most widely used structure.
-data elements are viewed as being stored in tables.
-a row represents a record.
-Column's represent a field. EMP name EMP salary, things like that.
-can relate data in one file with data in another file if both files share a common data
element.
Voordelen van het kopen van samenvattingen bij Stuvia op een rij:
Verzekerd van kwaliteit door reviews
Stuvia-klanten hebben meer dan 700.000 samenvattingen beoordeeld. Zo weet je zeker dat je de beste documenten koopt!
Snel en makkelijk kopen
Je betaalt supersnel en eenmalig met iDeal, creditcard of Stuvia-tegoed voor de samenvatting. Zonder lidmaatschap.
Focus op de essentie
Samenvattingen worden geschreven voor en door anderen. Daarom zijn de samenvattingen altijd betrouwbaar en actueel. Zo kom je snel tot de kern!
Veelgestelde vragen
Wat krijg ik als ik dit document koop?
Je krijgt een PDF, die direct beschikbaar is na je aankoop. Het gekochte document is altijd, overal en oneindig toegankelijk via je profiel.
Tevredenheidsgarantie: hoe werkt dat?
Onze tevredenheidsgarantie zorgt ervoor dat je altijd een studiedocument vindt dat goed bij je past. Je vult een formulier in en onze klantenservice regelt de rest.
Van wie koop ik deze samenvatting?
Stuvia is een marktplaats, je koop dit document dus niet van ons, maar van verkoper PatrickKaylian. Stuvia faciliteert de betaling aan de verkoper.
Zit ik meteen vast aan een abonnement?
Nee, je koopt alleen deze samenvatting voor €9,19. Je zit daarna nergens aan vast.