7 - Databases - TomorrowsTechnology andYou...

Info icon This preview shows pages 1–8. Sign up to view the full content.

View Full Document Right Arrow Icon
Tomorrow’s Technology  and You  Chapter 7   Database Applications and  Privacy Implications  Slid e 1
Image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
What Good Is a Database? Database  a collection of information stored in an  organized form in a computer Typically composed of one or more tables  A collection of related information A collection of records Database Software Application software (like word processing and spreadsheet software) Designed to maintain databases (collections of information) Slide 2
Image of page 2
 Database Advantages Advantages offered by computerized  databases:  Make it easier to store large quantities of  information  Make it easier to retrieve information  quickly and flexibly  Make it easy to organize and reorganize  information  Make it easy to print and distribute  information in a variety of ways  Slide 3
Image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Database Development Before you develop a database to  store data and generate information,  ask the following questions: 1) Why is the database needed? 2) Who will use the database? 3) What types of questions should the  database be able to answer? 4) What incentives will be available for  those that provide data to the database? http://www.vcrlter.virginia.edu/dimes/presentations/PORTER/SCIDB97/sld01 4.htm
Image of page 4
Database Basics A record is the information relating to  one person, product, or event. Each discrete piece of information in a  record is a field. Slide 5 Field Record Table
Image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Database Basics SQL (Structured Query Language) Most modern database management programs  support a standard language for programming  complex queries called SQL ( Structured Query  Language). SQL is available for many database management  systems. Programmers and sophisticated users don’t need to  learn new languages when they work with new systems. The graphical user interfaces allow point-and-click  queries that insulate users from the complexities of the  query language. Slide 6
Image of page 6
From File Managers to Database Management Systems File manager enables users to work with one file at a  time   Database management system  (DBMS)  manipulates data in a large collection of  files, cross-referencing between files as  needed Slid e 7
Image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 8
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern