Database Concepts, 9th Edition, by David M. Kroenke, David J. Auer, Scott L. Vandenberg, Robert C. Yoder. Prentice Hall, 2020. ISBN-13: 978-0-13-518814-9

eTextbook: Database Concepts, CourseSmart eTextbook, 9th Edition, ISBN-13: 978-0-13-516002-2

https://www.pearson.com/us/higher-education/program/Kroenke-Database-Concepts-9th-Edition/PGM2048266.html

• Homework: 40%
• Midterm: 30%
• Final Exam: 30%
• Note: Requests for makeup midterm exams must be requested before the midterm date. Requests after the exam date will not be honored.

None

IT 240 Introduction to Databases is included in the Liberal Studies program as a course with credit in the Scientific Inquiry domain. Courses in the Scientific Inquiry domain are designed to provide students with an opportunity to learn the methods of modern science and its impact on the world around us. Courses are designed to help students develop a more complete perspective about science and the scientific process, including: an understanding of the major principles guiding modern scientific thought; a comprehension of the varying approaches and aspects of science; an appreciation of the connection among the sciences; the fundamental role of mathematics in practicing science; an awareness of the roles and limitations of theories and models in interpreting, understanding, and predicting natural phenomena; and a realization of how these theories and models change or are supplanted as our knowledge increases.

• Students will understand the major principles guiding modern scientific thought. Students will demonstrate a mastery of the science content knowledge of their SID courses.
• Students will know that science, technology, and math serve as mechanisms for inquiry into the nature of the universe. Students will:dentify questions that can be answered through scientific investigations;
  • design and conduct a scientific investigation to test a scientific hypothesis;
  • use appropriate tools and techniques together, analyze, and interpret data to support or refute a scientific hypothesis;
  • develop descriptions, explanations, predictions, and models using evidence;
  • describe relationships between evidence and explanations using critical and logical thinking;
  • recognize and analyze alternative explanations and predictions;
  • communicate scientific procedures and explanations;
  • use mathematics in all aspects of scientific inquiry.
• Students will understand and appreciate the interrelationships among science, technology and math. Students will:
  • use technology and mathematics to identify a problem or design a solution to a problem;
  • give examples of how science and technology inform and influence each other.
• Students will understand and appreciate the role of science in society and in their lives. Students will:
  • Provide examples of how science and technology impact our lives, and how social needs and concerns impact our development of technology and scientific investigation;
  • develop positive attitudes towards science, technology, and mathematics;
  • establish an ongoing experiential/service-learning interest in science, technology, and mathematics.

• Students will understand understand the nature of science, technology, and mathematics. Students will:
  • provide examples of the abuse of science, including the representation of unfalsifiable claims as science and other forms of pseudoscience;
  • explain the strengths and limits of scientific inquiry;
  • explain the difference between evidence and inference, and the ?provisional nature of scientific explanations by providing examples of how our understanding of the workings of the world has changed in the past;
  • explain the difference between evidence and inference, and the ?provisional nature of scientific explanations by providing examples of how our understanding of the workings of the world has changed in the past;

How Learning Outcomes Will Be Met:

• identify the ubiquitous use of databases in everyday life
• demonstrate the effects of redundancy, inconsistencies and lack of integrity when databases are poorly designed
• apply Boolean logic, set theory, and relational algebra concepts in the construction of Structured Query Language (SQL) requests for retrieval of data
• predict and confirm results using empirical evidence from publicly accessible data
• create an Entity Relationship Diagram to graphically model user database requirements
• construct and maintain a database within a domain that implements the constraints of the relational database model.
   

Writing Expectation

Writing is integral for communicating ideas and progress in science, mathematics and technology. The form of writing in these disciplines is different from most other fields and includes, for example, mathematical equations, computer code, figures and graphs, lab reports and journals. Courses in the SI domain must include a writing component where that component takes on the form appropriate for that course (eg, lab reports, technical reports, etc.)
 

How Writing Expectations Will Be Met

Students will complete a project in which they will design, create, and maintain a database system. They will write SQL commands to create and maintain the database. Assignments will contain prompts in which students will demonstrate understanding of the course material through writing.