Logical and physical aspects of database management systems are surveyed. Data models including entity-relationship (ER) and relational models are presented. Physical implementation (data organization and indexing) methods are discussed. Query languages including SQL, relational algebra, relational calculus, and QBE are studied. Students will gain experience in creating and manipulating a database, and gain knowledge on professional and ethical responsibility and on the importance of privacy/security of data

Dong, Guozhu

English

CORE

Wright State University CORE Scholar Computer Science & Engineering Syllabi College of Engineering & Computer Science Winter 2010 CS 405/605-01: Introduction to Database Management Systems Guozhu Dong Wright State University - Main Campus, guozhu.dong@wright.edu Follow this and additional works at: https://corescholar.libraries.wright.edu/cecs_syllabi  Part of the Computer Engineering Commons, and the Computer Sciences Commons Repository Citation Dong, G. (2010). CS 405/605-01: Introduction to Database Management Systems. . https://corescholar.libraries.wright.edu/cecs_syllabi/828 This Syllabus is brought to you for free and open access by the College of Engineering & Computer Science at CORE Scholar. It has been accepted for inclusion in Computer Science & Engineering Syllabi by an authorized administrator of CORE Scholar. For more information, please contact library-corescholar@wright.edu. cs 405/605 01 Introduction to Database Management Systems Winter 2010 Description: Logical and physical aspects of database management systems are surveyed. Data models including entity-relationship (ER) and relational models are presented. Physical implementation (data organization and indexing) methods are discussed. Query languages including SQL, relational algebra, relational calculus, and QBE are studied. Students will gain experience in creating and manipulating a database, and gain knowledge on professional and ethical responsibility and on the importance of privacy/security of data. Prerequisite: CS 400/600 Data Structure and Software Design Instructor: Professor Guozhu Dong Office: Joshi 383 Phone No.: (937)-775-5066 Email: guozhu.dong@wright.edu Office hours: 1 :05-1 :55 T Th and by appointment. Use e-mail for short questions. Class time: 2:15-3:30, T Th Class venue: Russ Engineering Center 146 Course materials: Slides and other relevant materials will be available on WebCT, and handouts will be distributed in class. Students are responsible for collecting the handouts from classes. Required Textbook: R. Elmasri and S. 8. Navathe, Fundamentals of Database Systems, 5th edition, Addison Wesley. Reference texts: • 	 R. Sunderraman, Oracle 9 (or 8) Programming: A Premier, Addison Wesley. • 	 Raghu Ramakrishnan, and J. Gehrke, Database Management Systems, McGraw Hill. Any recent edition. • 	 Silberschatz, Korth, and Sudarshan, Database System Concepts, McGraw Hill. Any recent edition. • 	 J.D. Ullman, and J. Widom, A First Course in Database Systems, Prentice-Hall. Topics: 1. DBMS concepts and architecture (Chap 1, 2) [2 classes) 2. Entity-Relationship model and enhancements (Chap 3, 4) [2 classes] 3. Relational data model and relational algebra (Chap 5, 6) [3 classes) 4. SQL - a relational database language (Chap 8, 9) [3 classes] 5. ER and EER to relational mapping (Chap 7) [1 class] 6. Relation storage and file organizations, index structures (Chap 13, 14) [2 classes] 7. Other relational languages (the relational calculus, QBE -- brief discussion) [1 class] 8. Functional dependencies and relational design/normalization (Chap 10, 11) (if time permits) [2 classes] We plan to cover these topics in this order. Grading: A:[90, 100], 8:[80,90), C:[70,80), 0:[60,70), F:[0,60) Midterm 30%, Project 20%, Final 40%, Homeworks 10%. No late homeworks or projects will be accepted except for documented medical reasons. I may curve the final letter grades based on the overall distribution of scores. All exams are closed book and closed notes, except that you can use one sheet of notes for the midterm, and two sheets of notes far the final. There will be no make-up exams except for documented medical reasons. Project: The project is about database design, relational algebra, and SOL programming. You will be given a project specification, with details about the application and the problems. You will design the ER schemas (3%) and the relations schemas (3%) for the application, initialize your database with some given relations, implement the given queries in SOL (8%), and implement some of the given queries in relational algebra (3%). Yau can use MS-Access, Oracle, or other DBMS to implement your database and to test your SOL queries. The SOL queries must be entirely done by hand (without machine translations) to ensure understandability; they should also follow the SOL standard as discussed in the text. You need to write a report, which will be used to mark your project. In the report you should include your ER and relational schemas, your SOL codes of the queries, your relational algebra expressions of the queries, and results of test runs of your SOL queries. It is important that this final report be nicely presented; 3% marks will be allocated to the clarity and organization of the report. Independent work: All project and examination work must be your own. Academic dishonesty will be "rewarded" with a grade of "F". Important dates: • 2/2: in class midterm. • Project specification will be handed out around midterm. • 3/11: project will be due at the beginning of class. • 3:15-5:15, Thursday, 3/18: Final. Graduate students: Graduate students may be asked to do more than undergraduate students in the home works, projects and exams. 

CS 405/605-01: Introduction to Database Management Systems

Logical and physical aspects of database management systems are surveyed. Data models including entity-relationship (ER) and relational models are presented. Physical implementation (data organization and indexing) methods are discussed. Query languages including SOL, relational algebra, relational calculus, and QBE are studied. Students will gain experience in creating and manipulating a database, and gain knowledge on professional and ethical responsibility and on the importance of privacy/security of data

Wright State University CORE Scholar Computer Science & Engineering Syllabi College of Engineering & Computer Science Winter 2011 CS 405/605-01: Introduction to Database Management Systems Guozhu Dong Wright State University - Main Campus, guozhu.dong@wright.edu Follow this and additional works at: https://corescholar.libraries.wright.edu/cecs_syllabi  Part of the Computer Engineering Commons, and the Computer Sciences Commons Repository Citation Dong, G. (2011). CS 405/605-01: Introduction to Database Management Systems. . https://corescholar.libraries.wright.edu/cecs_syllabi/817 This Syllabus is brought to you for free and open access by the College of Engineering & Computer Science at CORE Scholar. It has been accepted for inclusion in Computer Science & Engineering Syllabi by an authorized administrator of CORE Scholar. For more information, please contact library-corescholar@wright.edu. cs 405/605 01 Introduction to Database Management Systems Winter 2011 Description: Logical and physical aspects of database management systems are surveyed. Data models including entity-relationship (ER) and relational models are presented. Physical implementation (data organization and indexing) methods are discussed. Query languages including SOL, relational algebra, relational calculus, and QBE are studied. Students will gain experience in creating and manipulating a database, and gain knowledge on professional and ethical responsibility and on the importance of privacy/security of data. Prerequisite: CS 400/600 Data Structure and Software Design Instructor: Professor Guozhu Dong Office: Joshi 383 Phone No.: (937)-775-5066 Email: guozhu.dong@wright.edu Office hours: 12:30-1:30 WF and by appointment. Use e-mail for short questions. Class time: 11 :00-11 :50, MWF Class venue: Russ Engineering Center 153 Course materials: Slides and other relevant materials will be available on WebCT, and handouts will be distributed in class. Students are responsible for collecting the handouts from classes. Required Textbook: R. Elmasri and S. B. Navathe, Fundamentals of Database Systems, 5th edition, Addison Wesley. Reference texts: • 	 R. Sunderraman, Oracle 9 (or 8) Programming: A Premier, Addison Wesley. • 	 Raghu Ramakrishnan, and J. Gehrke, Database Management Systems, McGraw Hill. Any recent edition. • 	 Silberschatz, Korth, and Sudarshan, Database System Concepts, McGraw Hill. Any recent edition. • 	 J.D. Ullman, and J. Widom, A First Course in Database Systems, Prentice-Hall. Topics: 1. DBMS concepts and architecture (Chap 1, 2) [2 classes] 2. Entity-Relationship model and enhancements (Chap 3, 4) [2 classes] 3. Relational data model and relational algebra (Chap 5, 6) [3 classes] 4. SQL - a relational database language (Chap 8, 9) [3 classes] 5. ER and EER to relational mapping (Chap 7) [1 class] 6. Relation storage and file organizations, index structures (Chap 13, 14) [2 classes] 7. Other relational languages (the relational calculus, QBE -- brief discussion) [1 class] 8. Functional dependencies and relational design/normalization (Chap 10, 11) (if time permits) [2 classes] We plan to cover these topics in this order. Grading: A:[90, 100], 8:[80,90), C:[70,80). 0:[60,70), F:[0,60) Midterm 30%, Project 20%, Final 40%, Homeworks 10%. No late homeworks or projects will be accepted except for documented medical reasons. I may curve the final letter grades based on the overall distribution of scores. All exams are closed book and closed notes, except that you can use one sheet of notes for the midterm, and two sheets of notes for the final. There will be no make-up exams except for documented medical reasons. Project: The project is about database design, relational algebra, and SOL programming. You will be given a project specification, with details about the application and the problems. You will design the ER schemas (3%) and the relations schemas (3%) for the application, initialize your database with some given relations, implement the given queries in SOL (8%), and implement some of the given queries in relational algebra (3%). You can use MS-Access, Oracle, or other DBMS to implement your database and to test your SOL queries. The SQL queries must be entirely done by hand (without machine translations) to ensure understandability; they should also follow the SQL standard as discussed in the text. You need to write a report, which will be used to mark your project. In the report you should include your ER and relational schemas, your SQL codes of the queries, your relational algebra expressions of the queries, and results of test runs of your SQL queries. It is important that this final report be nicely presented; 3% marks will be allocated to the clarity and organization of the report. Independent work: All project and examination work must be your own. Academic dishonesty will be "rewarded" with a grade of "F". Important dates: • 1/31: in class midterm. • Project specification will be handed out around midterm. • 3/9: project will be due at the start of the class. • 10:45-12:45, Friday, 3/18: Final. Graduate students: Graduate students may be asked to do more than undergraduate students in the home works, projects and exams. 

Wright State University CORE Scholar Computer Science & Engineering Syllabi College of Engineering & Computer Science Winter 2012 CS 405/605-01: Introduction to Database Management Systems Guozhu Dong Wright State University - Main Campus, guozhu.dong@wright.edu Follow this and additional works at: https://corescholar.libraries.wright.edu/cecs_syllabi  Part of the Computer Engineering Commons, and the Computer Sciences Commons Repository Citation Dong, G. (2012). CS 405/605-01: Introduction to Database Management Systems. . https://corescholar.libraries.wright.edu/cecs_syllabi/832 This Syllabus is brought to you for free and open access by the College of Engineering & Computer Science at CORE Scholar. It has been accepted for inclusion in Computer Science & Engineering Syllabi by an authorized administrator of CORE Scholar. For more information, please contact library-corescholar@wright.edu. CS 405/605 01 Introduction to Database Management Systems Winter 2012  Description: Logical and physical aspects of database management systems are surveyed. Data models including entity-relationship (ER) and relational models are presented. Physical implementation (data organization and indexing) methods are discussed. Query languages including SQL, relational algebra, relational calculus, and QBE are studied. Students will gain experience in creating and manipulating a database, and gain knowledge on professional and ethical responsibility and on the importance of privacy/security of data.  Prerequisite: CS 400/600 Data Structure and Software Design  Instructor: Professor Guozhu Dong Office: Joshi 383 Phone No.: (937)-775-5066 Email: guozhu.dong@wright.edu Office hours: 12:50-1:50 and by appointment. Use e-mail for short questions.   Class time: 10:25-11:40, TR Class venue: Russ Engineering Center 355  Course materials: Slides and other relevant materials will be available on pilot. Handouts will be distributed in class; students are responsible for collecting them in the classes.   Required Textbook: R. Elmasri and S. B. Navathe, Fundamentals of Database Systems, 6th edition, Addison Wesley.  Reference texts:   R. Sunderraman, Oracle 9 (or 8) Programming: A Premier, Addison Wesley.  Raghu Ramakrishnan, and J. Gehrke, Database Management Systems, McGraw Hill. Any recent edition.  Silberschatz, Korth, and Sudarshan, Database System Concepts, McGraw Hill. Any recent edition.  J.D. Ullman, and J. Widom, A First Course in Database Systems, Prentice-Hall.  Topics: 1. DBMS concepts and architecture (Chap 1, 2) [1 week] 2. Entity-Relationship model and enhancements (Chap 7, 8) [1 week] 3. Relational data model and relational algebra (Chap 3, 6) [1.5 weeks] 4. SQL - a relational database language (Chap 4, 5, 13) [1.5 weeks] 5. ER and EER to relational mapping (Chap 9) [0.5 week] 6. Relation storage and file organizations, index structures (Chap 17, 18) [1 week] 7. Other relational languages (the relational calculus, QBE -- brief discussion) [0.5 week] 8. Functional dependencies and relational design/normalization (Chap 15, 16) (if time permits) [1 week]  We plan to cover these topics in this order.  Grading: A:[90,100], B:[80,90), C:[70,80), D:[60,70), F:[0,60)                Midterm 30%, Project 20%, Final 40%, Homeworks 10%. No late homeworks or projects will be accepted except for documented medical reasons. The professor may curve the final letter grades based on the overall distribution of scores.  All exams are closed book and closed notes, except that you can use one sheet of notes for the midterm, and two sheets of notes for the final. There will be no make-up exams except for documented medical reasons.  Project: The project is about database design, relational algebra, and SQL programming. You will be given a project specification, with details about the application and the problems. You will design the ER schemas (3%) and the relations schemas (3%) for the application, initialize your database with some given relations, implement the given queries in SQL (8%), and implement some of the given queries in relational algebra (3%). You can use MS-Access, Oracle, or other DBMS to implement your database and to test your SQL queries. The SQL queries must be entirely done by hand (without machine translations) to ensure understandability; they should also follow the SQL standard as discussed in the text. You need to write a report, which will be used to mark your project. In the report you should include your ER and relational schemas, your SQL codes of the queries, your relational algebra expressions of the queries, and results of test runs of your SQL queries. It is important that this final report be nicely presented; 3% marks will be allocated to the clarity and organization of the report.  Independent work: All project and examination work must be your own. Academic dishonesty will be “rewarded" with a grade of “F".  Important dates:   1/31: in class midterm.   Project specification will be handed out around midterm.   3/8: project will be due at the start of the class.  10:45-12:45, Thursday, 3/15: Final.  Graduate students: Graduate students may be asked to do more than undergraduate students in the home works, projects and exams. 

https://corescholar.libraries.wright.edu/cgi/viewcontent.cgi?article=1790&amp;context=cecs_syllabi

CS 405/605-01: Introduction to Database Management Systems

Abstract

Similar works

Full text

Available Versions

CORE

CORE

CORE