Introduction to Database professor: Thomas L. Brown office: Journalism Room 202 email: tom.brown@tamuc.edu website: http://csci.website conference: Jour 110 T/R at 12:00 class: Jour. 110 T/R 12:30 CSci 340: Introduction to Database Course Description This course offers lecture and online interaction to provide a foundation in data management concepts and database systems. It includes representing information with the relational database model, manipulating data with an interactive query language(SQL) and database development including database security, integrity and privacy issues. Audience Students planning to enroll for this course should have mastered the fundamentals of programming and basic data structures. Student Learning Outcomes* Install, configure, and interact with a relational database management system; Describe, define and apply the major components of the relational database model to database design; Learn and apply the Structured Query Language (SQL) for database definition and manipulation; Utilize a database modeling technique for a single entity class, a one-to- one (1:1) relationship between entity classes, a one-to-many (1:M) relationship between entity classes, a many-to-many (M:M) relationship between entity classes, and recursive relationships; Define, develop and process single entity, 1:1, 1:M, and M:M database tables; Learn and implement the principles and concepts of information integrity, security and confidentiality; Apply ethical computing concepts and practices to database design and implementation. * measured by participation, quiz, and final exam results References and Materials: https://www.w3schools.com/sql/default.asp MySQL database software and associated documentation is available for a free download: https://dev.mysql.com/downloads/installer/ MySQL tutorials: https://www.w3schools.com/sql/default.asp https://www.mysqltutorial.org/ A usb flash drive to store software, course files and documents. Measurement and Evaluation: Grades will be based upon assignment and exam scores. A point total in the range of 270-300 will earn the grade "A", 240-269 a "B", 210-239 a "C" and so on. College policy must be followed to obtain an "X" (incomplete). Unless circumstances are beyond control, the student is expected to withdraw instead of delaying completion of the course. Tuesday and Thursday 12:30pm Page 2 Journalism Building Room 110 COURSE POLICY and PROCEDURES Activities and Requirements 0. Assigned Readings: The student is expected to retrieve and read references related to assignments and class discussions. 1. Attendance: The student is expected to attend orientation sessions, lectures, and scheduled examinations. Regular interaction ensures that expectations are understood, and feedback received for monitoring and assessing progress. 2. Participation: The student is expected to monitor the course website, interact with classmates, and implement course software and example application code. 3. Assignments and Final Exam: These graded activities are based upon course objectives related to assigned readings, study questions, and classroom exercises. The student is expected to complete each activity on the scheduled date. Should a deadline be missed, the next grade for the same type activity will be recorded for both. 4. Intellectual Honesty and Ethics: By departmental policy, the discovery of plagiarism, collusion, or the use of unauthorized aids (e.g. camera) will result in a grade of "F" on that graded activity. A subsequent breach of this policy mandates a grade of "F" for the course. Also, the student is expected to follow university, departmental and class policies and procedures for information security and privacy. 5. Conduct: All students enrolled at this university shall follow the tenets of common decency and acceptable behavior conducive to a positive learning environment (see Texas A&M University Student Handbook). 6. Special Accomodations: Students in need of accomodations for disabilities should contact the Director of Disability Resources and Services, Gee Library Room 132, Phone (903)886-5150 or (903)886-5835 or Fax (903)468-8148, or email StudentDisabilityServices@tamuc.edu. 7. A&M-Commerce will comply in the classroom, and in online courses, with all federal and state laws prohibiting discrimination and related retaliation on the basis of race, color, religion, sex, national origin, disability, age, genetic information or veteran status. Further, an environment free from discrimination on the basis of sexual orientation, gender identity, or gender expression will be maintained. 8. Campus Concealed Carry: Texas Senate Bill-11 (Government Code 411.2031, et al.) authorizes the carrying of a concealed handgun in Texas A&M University-Commerce buildings only by persons who have been issued and are in possession of a Texas License to Carry a Handgun. Qualified law enforcement officers or those who are otherwise authorized to carry a concealed handgun in the State of Texas are also permitted to do so. Pursuant to Penal Code (PC) 46.035 and A&M-Commerce Rule 34.06.02.R1, license holders may not carry a concealed handgun in restricted locations. For a list of locations, please refer to (http://www.tamuc.edu/ aboutUs/policiesProceduresStandardsStatements/rulesProcedures/ 34SafetyOfEmployeesAndStudents/34.06.02.R1.pdf) and/or consult your event organizer). Pursuant to PC 46.035 the open carrying of handguns is prohibited on all A&M-Commerce campuses. Report violations to the University Police Department at 903-886-5868 or 9-1-1. 9. The University's Pandemic Response: A&M-Commerce requires the use of face-coverings in all instructional and research classrooms/laboratories. Exceptions may be made by faculty where warranted. Faculty have management over their classrooms. Students not using face-coverings can be required to leave class. Repetitive refusal to comply can be reported to the Office of Students’ Rights and Responsibilities as a violation of the student Code of Conduct. Students should not attend class when ill or after exposure to anyone with a communicable illness. Communicate such instances directly with your instructor. Faculty will work to support the student getting access to missed content or completing missed assignments. The Counseling Center at A;&;M-Commerce, located in the Halladay Building, Room 203, offers counseling services, educational programming, and connection to community resources for students. Students have 24/7 access to the Counseling Center’s crisis assessment services by calling 903-886-5145. For more information regarding Counseling Center events and confidential services, please visit www.tamuc.edu/counsel CSci 340.01B COURSE OUTLINE / CALENDAR Page 3 Week Study Topic/Activity ---- ----------------------------------------------------------------------- 1 An introduction to databases and SQL Tuesday/Thursday 12:30 2 Using SQL development tools " 3 Retrieving data from a single table " 4 Retrieving data from multiple tables " 5 Inserting, updating and deleting data " 6 Coding summary queries " 7 Coding subqueries " 8 Working with data types " 9 Using functions " 10 Designing a database " 11 Creating databses, tables and indexes " 12 Creating views " 13 Database administration " 14 Database security " 15 Database backup and restore " 16 Final Exam: Thursday December 12th, 10:30am