220 likes | 383 Views
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
E N D
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 • Understand basic user interface design principles to support information processing
Why Are You Here? • It is a required course. • But hopefully there is more!
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.
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
Course Grading • Attendance / Participation: 5% • Homework: 15% • Labs: 15% • Midterm: 30% • Final: 35%
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
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)?
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.
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
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!
What kind of data do you have? • Class Schedules • Contacts • Names • Phone Numbers • Address • Email • Food Specials • Movies, Music Collect
How do you store data? • Paper • Post-it Notes • Excel • iTunes • Address Book
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
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.
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
List Modification Issues • Redundancy and multiple themes create modification problems: • Deletion problems • Update problems • Insertion problems
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.
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).
One week down 15 to go! • Next week • Big Data and why Data base • First Lab • First homework due!