Remerciez-le!

Remerciez @Admin pour avoir partagé cet document gratuitement, de la manière la plus simple, en partageant sur les réseaux sociaux.

Course guide Database Management in Construction Course Number CE C CE C L Semester Second Semester - Meeting Time On-site Hours As requested Generally I am on a work-from-home set-up during the day but I can meet with students at any time that's convenie

Database Management in Construction Course Number CE C CE C L Semester Second Semester - Meeting Time On-site Hours As requested Generally I am on a work-from-home set-up during the day but I can meet with students at any time that's convenient with a hours ? notice Most weeks generally every Tuesdays and Wednesdays I will be in the temporary faculty room at Room found on ?rst oor south wing Course Description The primary goal of this class is to learn principles and practices of database management and database design Over the course of the semester we will discuss the database relational database design normalization SQL queries reports and other interfaces to database data and documentation Lectures will also cover writing ethical and privacy issues associated with database systems In- class instruction and exercises will focus on the fundamentals for creating sophisticated interactive and secure database applications For the ?rst few weeks of class we will study PHP in order to better understand how data structures are stored and retrieved on computer systems as well as providing a robust interface for accessing databases via the Web Then we will learn the fundamentals of database design using a variant of MySQL called MariaDB MySQL and MariaDB are powerful relational database management systems used at companies such as Google and Facebook We use PHP and MySQL as tools because they are commonly and freely available and provide substantially the same set of tools as commercial databases such as Microsoft SQL Server and Oracle Although there will be a substantial programming PHP component to this course previous programming experience is not required At the conclusion of this course students should Understand the fundamentals of how data is stored in computer systems Know the fundamentals of Structured Query Language SQL and how it can be used to store and retrieve data from a relational database Be able to apply the principles used in class to build a web-based database application from the ground up Page CGrading Programming assignments of ?nal grade A series of short programming and database exercises designed to complement the hands-on work done in class These exercises must be completed each week before the start of class They will represent not only a demonstration of the students ? grasp of concepts covered in the course they will also provide a convenient code base from which students can draw when designing their own projects There will be assignments worth points each and assignments worth points each that will represent of the ?nal grade Group Tutorial of ?nal grade As an initial collaboration e ?ort each group of - students will develop and present an inclass tutorial on a database subject that will be assigned in class Grades will be based on both the content of the tutorial and the presentation Final Project of ?nal grade The ?nal project will also be done in groups of - For the ?nal project the groups will select or be presented with a real-world scenario for