COEN 150 Databases and Applications
Course Syllabus

Instructor:

Meets:

URL:

Bulletin description:

Prerequisites:

You may not receive credit for both COEN 150 and COSC 153 because the two are similar classes. This semester's COSC 153 meets MW 5:45 - 7:00 in Cudahy 118 taught by Dr. Praveen Madiraju. You are welcome to visit his class for an alternate point of view. COSC 153 will place slightly more emphasis on database concepts and theory; COEN 150 will place slightly more emphasis of design and development of applications.

Text:

English: Correct English grammar, style, usage, and spelling is expected in homework, programming comments, exam solutions, emails, and any other communication. You must write anyway, so why practice writing poorly? To help you practice writing well, we recommended: William Pfeiffer, Technical Writing: a Practical Approach (6th Edition) Prentice Hall, Englewood Cliffs, NJ, 2005. ISBN: 978-0131198166. This is the book you'll use in Senior Design. 5th Edition is fine, too. See Corliss's advice: We Expect Good English

Course Goals:

• Introduce entity-relationship models for databases
• Present the relational data model for databases
• Describe SQL, a database query language
• Provide practical database design methods that use UML
• Describe the physical and logical methods for storing and retrieving data from a database
• Present optimized techniques for processing database queries
• Introduce fundamental concepts for transaction processing
• Present an overview of advanced database concepts including object databases, security issues, and distributed databases

Course Objectives: By the end of this course, you should

• Know how to model data using the entity-relationship model
• Be able to model data using a relational model
• Be able to manipulate relational data using relational algebra and calculus
• Understand and be able to use the basic SQL constructs
• Be able to identify functional dependencies in relational databases
• Know several database design algorithms and be able to use them
• Know how to design a database using UML
• Understand the relationships among disk organization, file structures, and hashing
• Know several indexing structures for files and be able to use them
• Know several algorithms for processing queries and be able to use them
• Understand how to tune a database
• Understand the basic concepts behind transaction processing

Design project: Each student will complete a design project during the last half of the semester.

Grades: A - 90; A/B - 80; B - 70; B/C - 60; C - 50; C/D - 40; D - 30.

• 30% Design project
• 40% Individual homework
• 10%
• 20% See University's Fall Final Examination Schedule

Assignments handed in later than the beginning of the class period assigned may be subject to a penalty of 20% for each class period late.

Students taking this course for graduate credit will complete additional work in each homework assignment.

Our programming languages are primarily Java and MySQL. We also may see Oracle and Access databases and C#, PHP, Perl, or Matlab programming languages. Your projects will use software environments of your client's choice.

Assignments: Your written assignments must be neat and typed to the extent that is practical. I will make copies of homework papers public through either electronic or physical means. You should prepare each assignment so that you will be proud to have it displayed for public scrutiny.

Assignment 0: If you did not complete the "Who Am I?" form in class, you should complete it on line at www.eng.mu.edu/corlissg/150.07F/oneAssign00.html.

Assignment 1: Databases and Database Users. Due Wednesday, September 5.

Attendance: expected. Excessive absences may be penalized. It is your responsibility to obtain missed lecture material. Assignments are due as scheduled, although I can be understanding when necessary. See College of Engineering policy on Academic attendance

Classroom etiquette: In class, it is expected you will demonstrate respect for your fellow classmates and instructor. This is accomplished by:

1. Being to class on time (on those rare occasions when you may be late, please enter quietly);
2. Waiting until the speaker (instructor or guest) has completed the lecture before you begin packing up (if it seems the topic is not wrapping up, please remind them of the time); and
3. Turning off audio settings of cell phones, pagers and watches (and any other sound making devices that will have been created since the time of this writing). Simply put, common courtesy, manners, and respect are expected.

Communications: I will rely heavily on electronic communications, and I encourage you to do the same. Homework assignments, hints, and items of interest will be distributed by e-mail and on the class Web site. You should check daily for electronic mail. You may reach me at George.Corliss {at} Marquette.edu

Ethics: Students and faculty are expected to abide by the ACM Code of Ethics and Professional Conduct and the IEEE Code of Ethics.

Academic honesty: YOU must be actively involved in learning the material to be covered in this course. When working on assignments, some of your best learning may actually occur as you help others. However, the homework assignments are meant to reflect your work, not the work of others. Therefore,

• You may CONSULT with others when you work on homework assignments and other assignments.
• You will CREDIT all people with whom you consult and any other sources you use (textbooks, Web, etc.) in the appropriate section of your assignment work.

See College of Engineering policies on

  Academic policies

  Academic honesty

  Academic attendance

Colloquia: Departments have regular research colloquia to give you a chance to hear from experts. Some talks are advanced research; others are about current practice in industry. Some speakers are former students; some are known around the world; some are both. We strongly encourage you to participate in departmental colloquia, and we will often call your attention to coming events of special notice. Usual colloquium times: MSCS - Friday 4:00 in Cudahy 401, EECE - Tuesday 3:00 in Olin 202, BIEN - Friday noon in Olin 202, all subject to change.

Electronic resources: Everyone who accesses or uses Marquette University's electronic resources (as defined in the policy) are bound by the responsibilities and limitations outlined in the Marquette Acceptable Use of Electronic Resources policy. We encourage you to review this policy.