In addition, there are many solutions to problems that are prepared as a group effort in class, with students presenting the solutions to the rest of the class for discussion. Social and Ethical Issues Please list the topics that address the social and ethical implications of computing covered in all course sections. Estimate the class time spent on each topic. Graded through test questions Theoretical Content Please list the types of theoretical material covered, and estimate the time devoted to such coverage. Please describe the analysis and design experiences common to all course sections.
Students learn the fundamentals of the database design process.
In addition to lifecycle issues, they learn how to use the Entity Relationship model to support conceptual database design. They also learn the relational model and how to map an Entity Relationship diagram to a relational design. We also address relational design from a theoretical point of view by looking at the properties of a good relational design and at how functional dependency theory can be sued to evaluate and produce relational designs. As part of the course project, students get to apply these concepts to an actual database design. Students also address design issues related to behavioral properties of database applications, query specification, and application interface design.