1 / 22

IST 210 - Organization of Data

IST 210 - Organization of Data. Lecture 1a. Course Objectives. Understand the importance of data, databases, and database management Design and implement a database Design SQL queries to access databases Understand web-based databases Understand how different databases exchange data

mariko
Télécharger la présentation

IST 210 - Organization of Data

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. IST 210 - Organization of Data Lecture 1a

  2. Course Objectives • Understand the importance of data, databases, and database management • Design and implement a database • Design SQL queries to access databases • Understand web-based databases • Understand how different databases exchange data • Understand basic user interface design principles to support information processing

  3. Why Are You Here? • It is a required course. • But hopefully there is more!

  4. Course Organization • 2 “Lectures” a week • Tuesdays and Thursdays – 11:15 a.m. – 12:30 p.m. • 1 lab a week • Tuesdays – 1 p.m. – 2:15 p.m. • Reading • To be completed before class on Tuesday • Homework • Due - Tuesday at 11:59pm turned in via the appropriate drop box on Angel. • One Amnesty day – Turn in 1 assignment 24 hours late.

  5. Course Resources • Required Book • Database Concepts, Sixth Edition • Course Website • Syllabus • Schedule and Assignments • Announcements • www.personal.psu.edu/nna102/IST210 • Angel Site • Turn in Homework • Grades • Announcements go out via Angel email

  6. Course Grading • Attendance / Participation: 5% • Homework: 15% • Labs: 15% • Midterm: 30% • Final: 35%

  7. Course Software • Data base • Microsoft SQL Server • Data base Management Software • Microsoft SQL Server Management Studio • Website hosting • IST UP Webspace - https://my.up.ist.psu.edu/username. • Web Development Languages • HTML • CSS • PHP

  8. Four Corners • Top Left - If you were an action figure what would your accessory / accessories be? • Top Right – You’ve been given access to a time machine.  Where and when would you travel to? • Bottom Left – Free Choice, Draw something about yourself you would like to share with the class that will help everyone remember you. • Bottom Right – What do you want to be when you grown up (finish college)?

  9. About Me • I graduated from Penn State in 1998 • Returned to Penn State a few years back to work at ARL • Completed the IST Masters last year • I work full time at ARL • This is my first Penn State class as an instructor • I am a single father and live in State College with my 5 year old son.

  10. What is Data? Computer Human • Facts and statistics collected together for reference or analysis • The quantities, characters, or symbols on which operations are performed by a computer, being stored and transmitted in the form of electrical signals and recorded on magnetic, optical, or mechanical recording media • Things known or assumed as facts, making the basis of reasoning or calculation

  11. Announcements • No Lab this week! • Read Chapter 1 - pp. 1-23 • If you have any concerns about anything, Talk to me sooner rather than later!

  12. End of Class 1

  13. What kind of data do you have? • Class Schedules • Contacts • Names • Phone Numbers • Address • Email • Food Specials • Movies, Music Collect

  14. How do you store data? • Paper • Post-it Notes • Excel • iTunes • Address Book

  15. List Activity • Get in groups of 3 people • Nominate one person as the scribe, and have them type your list • Make a list of all the data you store and how it is stored

  16. Problems with Lists • Redundancy - In a list, each row is intended to stand on its own. As a result, the same information may be entered several times. • For Example: A list of Projects may include the Project Manager’s Name, ID, and Phone Extension. If a particular person is managing 10 projects, his/her information would have to be entered 10 times.

  17. Problems with Lists • Multiple Themes - In a list, each row may contain information on more than one theme. As a result, needed information may appear in the lists only if information on other themes is also present. • For Example: A list of Projects may include Project Manager information (Name, ID, and Phone Extension) and Project information (Name, ID, StartDate, Budget) in the same row

  18. List Modification Issues • Redundancy and multiple themes create modification problems: • Deletion problems • Update problems • Insertion problems

  19. List Modification Issues

  20. Types of Data • Objects that contain data have an associated data type that defines the kind of data. The following objects have data types: • Columns in tables and views. • Parameters in stored procedures. • Variables. • Transact-SQL functions that return one or more data values of a specific data type. • Stored procedures that have a return code, which always has an integer data type.

  21. Types of Data • Assigning a data type to an object defines four attributes of the object: • The kind of data contained by the object. • The length or size of the stored value. • The precision of the number (numeric data types only). • The scale of the number (numeric data types only).

  22. One week down 15 to go! • Next week • Big Data and why Data base • First Lab • First homework due!

More Related