====== LI844 Database Design 3 credit hours====== |Description | This course provides an introduction to the fundamentals of database design, including analyzing information requirements, developing an entity-relationship model, organizing data into a relational database, and querying the database. The focus is on database applications and assessing designs to determine efficient database access for various clients. | |syllabus | [[slim:classes:844:li844_syllabus]]| ---- ====== Instructor(s) ======= ^Instructor^email^fon/text^other^ |[[scholars:Arendt, Anne]]|aarendt@emporia.edu or anne.marie.arendt@gmail.com||d| ---- ====== Text Book(s) and Required Readings ======= ^Title^b^c^d^ |[[books:2014Watt_Database Design]]|b|c|d| |[[books:xx]]|b|c|d| |[[books:xx]]|b|c|d| |[[articles:xx]]|b|c|d| ---- ====== Useful Lists ======= ^List^ |[[slim:classes:844:li844_class_roster]]| |[[slim:classes:844:li844_reading_list]]| |[[slim:classes:844:li844_database_use_in_libraries]]| |[[slim:classes:844:li844_gis_in_libraries]]| |[[slim:classes:844:li844_trends_in_database_technologies]]| ---- ====== Major Projects ======= ^Project^Due Date^^ |[[class:844:xx]]|6/17| |[[class:844:xx]]|7/8| |[[class:844:xx]]|7/22| |[[class:844:xx]]|8/10| ---- ====== Weekly Tasks ======= ^Week^Dates^Task^ |01| 5/21 - 5/27 |post mini-biography to discussion forum|[[slim:classes:844:li844mod01]]| |01||yy| |02| 5/28 - 6/03 |describe the principles of relational database design via discussion board |[[slim:classes:844:li844mod02]]| |03| 6/04 - 6/10 |research and discuss current trends in database technologies via discussion board |[[slim:classes:844:li844mod03]]| |04| 6/11 - 6/17 |conduct an analysis of information requirements and recommendations while considering maintainability|[[slim:classes:844:li844mod04]]| |05| 6/18 - 6/24 |describe the entity-relationship model, creating tables and fields, and establishing keys and relationships between data sets |[[slim:classes:844:li844mod05]]| |06| 6/25 - 7/01 |conduct an analysis of information requirements for the purpose of designing a relational database |[[slim:classes:844:li844mod06]]| |07| 7/02 - 7/08 |create a relational database that will meet specific information requirements offered in assignment detail |[[slim:classes:844:li844mod07]]| |08| 7/09 - 7/15 |work on database project |[[slim:classes:844:li844mod08]]| |09| 7/16 - 7/22 |document the purpose of your relational database design, including entity-relationship model, tables, fields, keys and relationships between data sets|[[slim:classes:844:li844mod09]]| |10| 7/23 - 7/29 |write instructions for database use and modification |[[slim:classes:844:li844mod10]]| |11| 7/30 - 8/05 |evalutate database design and performance via peer review |[[slim:classes:844:li844mod11]]| |12| 8/06 - 8/10 |finalize database, documentation, lessons learned, and best practices |[[slim:classes:844:li844mod12]]|