CS669_Module1Lecture - Module 1 Page 1 of 20 Warren...

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

View Full Document Right Arrow Icon
metcis669_09_sp1_bshdy_lec01 is displayed here Download Module 1 This is a single, concatenated file, suitable for printing or saving as a PDF for offline viewing. Please note that some animations or images may not work. Module 1 Study Guide and Deliverables Concept Readings: Coronel & Morris, chapters 1 and 2 SQL Readings: Coronel & Morris, sections 7.1 through 7.4 of chapter 7 Assignments: Concepts Assignment 1, SQL Lab 1, and Term Project Iteration 1 due Tuesday, May 19 at 6:00 AM ET Term Project Milestones: Read the term project specification Decide if you are doing the default or student-defined term project and submit your decision in Assignment 1.3 Assessments: Quiz 1 due Tuesday, May 19 at 6:00 AM ET Which First? Read the book chapters before reading the online lectures. Terminology Note The more common name for what our text terms the internal model is the logical model . Section 2.4.3 on page 37 of the textbook instructs you to prefix each attribute name with the name of its containing entity. However, prefixing attribute names in this manner was necessary decades ago when many DBMS would not support having the same column name in multiple tables. A better contemporary practice is to name columns in different tables the same when the columns represent the same attributes of different types of objects. In these cases the domains and data types should be identical. Best practice is to explicitly name the table for each column in a request—for example SELECT My_table.my-column . © 2015 Trustees of Boston University. Materials contained within this course are subject to copyright protection. Lecture 1 - Database Systems Introduction Let's begin by defining some database systems terminology. Data are raw facts, meaning facts have not yet been processed to reveal their meaning. D ata is processed to yield information on which business decisions can be based. Data management is a discipline that focuses on the proper generation, storage, processing and retrieval of data. Typically, data management requires the use of a computer database. A database is a shared, integrated computer structure that houses a collection of end-user data, and metadata about the stored data. A well-designed database facilitates data management and becomes a valuable information generator. A poorly designed database is likely to lead to errors in processing data and to bad decisions. Let's summarize some key points: Data constitute the building bocks of information. Information is produced by processing data. Information reveals the meaning of data. Good, relevant, and timely information is the key to good decision making. Good decision making is critical to organizational survival in a competitive environment. What a Database Is A database is a shared, integrated computer structure that houses a collection of user data and metadata. Metadata is data about data, such as descriptions of the relationships that exist among data. A database management system (DBMS) is a collection of programs that manages the database structure and controls access to the data stored in the database.
Image of page 1

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

View Full Document Right Arrow Icon
Image of page 2
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