LIS 470 DATABASE DEVELOPMENT AND MANAGEMENT (3) 001

Please read and download the full version of this course syllabus HERE

Academic Year: 

Semester: 

Course ID and Name: 

Section Number: 

Course Syllabus

Course Prerequisites: 

 This course assumes that all students have had a general background in computing literacy. If you have difficulties to meet this requirement, please see the instructor immediately.

 

 Software Required

  • ·         Windows platform (you won’t be able to run Microsoft ACCESS under a mac computer!)
  • ·         Microsoft ACCESS 2010 (You need it through the entire semester. Most computer labs at campus should have it installed. You can buy an education copy at bookstore if you want install it in your own computer)
  • ·         Microsoft Visio 2010 (You need it for the first half of the course.  Most computer labs at campus should have it installed. You can buy an education copy at bookstore or obtain a free trial copy for 60 days from Microsoft.
  •  

Course Description: 

 This course is designed to help students develop a broad understanding of modern database management systems. It covers theory, methods, and techniques widely used today to design and develop a relational database system. The course emphasizes the applications of fundamental database principles in a stand-alone database environment using MS Access on the Windows platform. Applications under Internet environment will also be discussed on the class using MySQL in the Linux platform. The course takes a problem-based learning approach through ample hands-on experiences to prepare the student for designing and utilizing real world database systems in a team or individual working environment.

Course Objective: 

 Students who successfully complete this course will be able to:

  • ·         Understand the basic concepts, terminology, methods, and issues related to database systems and database design;
  • ·         Be familiar with Microsoft Access, currently the most popular database software in the office environment;
  • ·         Gain experiences of MySQL, currently the most popular open-source database system in small to middle-size enterprise business environment;
  • ·         Use SQL to write database queries and generate database reports;
  • ·         Perform database design analysis to address practical problems concerning the management of information resources.

Required Course Materials: 

 ·         Required Textbook: "Illustrated Series Microsoft Office Access 2010, Introductory" by Lisa Friedrichsen ISBN:1-4239-0518-0 (You can get this book from amazon. com at approximately $38)

·         Recommended Textbook: "Datebase Systems, Design, Implementation, & Management", Tenth edition by Peter Rob & Carlos Coronel ISBN:1-4239-0201-7 (You also can get this book from amazon. com at approximately $108)

·         Complementary materials may be distributed through web during the class when appropriate.

Course Requirements: 

Course Grading: 

 Your course evaluation will be based on the quality of your participation in each of the stated course requirements. A final course grade will be calculated considering each graded requirement, assignments, quizzes, group/individual project, and your class participation. It is the students' responsibility to check their grades to make sure that they are properly credited for assignments submitted.

 

A 450 or above

B 400 - 449

C 350 - 399

D 300 - 349

F 299 or below

Grade of any type can only be appealed within one week from the day when that grade becomes available to you. The final grades may be curved as needed.

 

Assignments

60%

300

 

Database Design

75

 

 

 

Database Normalization

75

 

 

 

Structural Query Language 1

75

 

 

 

Structural Query Language 2

75

 

 

Individual Project

 

32%

160

 

Section 1: Database Design

40

 

 

 

Section 2: Implementation (Tables)

40

 

 

 

Section 3: Forms

40

 

 

 

Section 4: Data Retrieval (Queries & Reports)

40

 

 

Class Participation

8%

40

Total:

100%

500

 

 

Course Policies: 

        Academic Code of Integrity

Students are expected to abide by The University of Arizona Code of Academic Integrity. 'The guiding principle of academic integrity is that a student's submitted work must be the student's own.' If you have any questions regarding what is acceptable practice under this Code, please ask an Instructor.

        Accommodating Disabilities

The University has a Disability Resource Center. If you anticipate the need for reasonable accommodations to meet the requirements of this course, you must register with the Disability Resource Center and request that the DRC send me, the Instructor, official notification of your accommodation needs as soon as possible. Please plan to meet with me by appointment or during office hours to discuss accommodations and how my course requirements and activities may impact your ability to fully participate.

        Incompletes

The 1997-8 University of Arizona General Academic Manual, p.23 reads

 

The grade of I may be awarded only at the end of a semester, when all but a minor portion of the course work has been satisfactorily completed. The grade of I is not to be awarded when the student is expected to repeat the course; in such a case the grade of E must be assigned. Students should make arrangements with the instructor to receive an incomplete grade before the end of the semester ...

 

If the incomplete is not removed by the instructor within one year the grade will revert to a failing grade.

College of Social and Behavioral Sciences
 
 
iSchools