Database systems a practical approach to design, implementation, and management

1、cpsc 3131 introduction to database systems fall 2007instructor information name: dr. shamim khanoffice: center for commerce and technology (cct) room 444office hours: tue 10:00 am - 12:00 pm, 2 pm 5 pmwed 11:00 am - 12:00 pmfri 11:00 am - 12:00 pm, 1:30 pm 4:30 pmother times by appointment email: kh

2、an_ (preferred method of contact)website(s): , /khanoffice phone: 706/565-3519; dept. phone: 706/568-2410; dept. fax: 706/565-3529 course detailsmeets mw 06:00pm-07:15pm in cct 407course website at prerequisite(s

3、)cpsc 2108 data structures (preferably with a grade of c).description as described in the csu catalog (/catalogs/2007-2008/courses/cpsc.htm), this course covers the fundamentals of database systems, different database models, sql, database design and integrity, and normal

4、ization. hands-on work using a dbms will be considered. the course includes practical work. learning objectives1. students will learn the fundamental concepts of database systems.2. students will have an understanding of the relational database management model.3. students will gain knowledge about

5、database design models.4. students will understand entity-relationship diagramming and normalization thoroughly.5. students will learn the structured query language (sql) of database management systems.6. students will learn about data integrity, uncontrolled redundancy and update anomalies.7. stude

6、nts will understand transactions, locking mechanisms and database recovery.required textbook title: database systems: a practical approach to design, implementation and management, 4th edition, 2005authors: connolly, t., and begg, c.,publisher: addison-wesleyisbn: isbn 0321210255supplementary materi

7、alslecture notes, class handouts, external research (online and offline)online interfacewebct vista will be the primary method of interaction in this course. it will be used for e-mail communication as well as for submitting assignments. latest information on the course such as announcements on exam

8、s will also be will be made available online through it. you can access webct vista at: /. click on the log-in link to activate the webctvista logon dialog box, which will ask for your webct username and password. if you do not have a password already, new student passwords o

9、n webctvista have been set to the students birth date in the format of ddmmyy. (example - birthday of oct. 25, 1978 is 251078). if you try the above and webct will not let you in, please click on the new online support center for vista is available to you 24 hours a day, 7 days a week. once youve en

10、tered webctvista, you will see a list of courses you have access to. clicking on the name of a course will take you to the courses home page. if you dont see the introduction to database systems 1 fall 2007 cpsc3131-01 course in the list, please e-mail me immediately. once you have clicked on the co

11、urses name and accessed the particular course itself, you will find a home page with links to other sections and tools, and a menu on the left-hand side. please explore the online interface and become familiar with components such as: calendar, email, assignments, more resources and the syllabus. as

12、sessment components5 assignments (may involve lab work)10 points each (counts for 50%)classroom quizzes10 points (for 10%)1 mid-term exam20 points (counts for 20%) 1 non-comprehensive final exam20 points (counts for 20%)total points possible100 points maximum / 100%grading scale a: 90-100 % b: 80-89

13、 % c: 70-79 % d: 60-69 %f: below 60 %assignments five assignments will be given that build upon the concepts covered in the textbook and have to be completed on time. assignment deadlines are not flexible. late assignments are not accepted for credit. assignment submissions will be via webctvista us

14、ing assignment drop boxes. classroom quizzesthere will be short online quizzes during most lectures to test your understanding of the material covered during the current lecture or occasionally the previous lecture. exams1 mid-term exam and 1 non-comprehensive final exam are planned. you will be giv

15、en advance notice of these exams. multiple choice, true/false, fill in the blanks and short answer questions may appear in these exams. all exams are expected to be your own work. if you miss an exam, no make up will be allowed. exams will be held in class and may be conducted online through webct.t

16、he tentative schedule given below will help you plan your study over the semester.week startinglecture topicchaptersassessment due8/201. introduction and overview 2. the relational model 1,23,48/272. the relational model (cont.) 3,49/33. introduction to sql as a data manipulation language5assignment

17、 19/103. introduction to sql as a data manipulation language (cont.) 4. normalization513,149/174. normalization (cont.) 5. conceptual database design11,129/245. conceptual database design (cont.)assignment 210/15. conceptual database design (cont.) revision for mid-term exam10/86. logical database d

18、esign 16mid-term exam10/156. logical database design (cont.) 7. physical database design6,17,18, app. c assignment 310/227. physical database design (cont.)10/297. physical database design (cont.)8. database application design5,6,7,911/58. database application design (cont.)assignment 411/129. trans

19、action management2011/199. transaction management (cont.)10. database security 6,1911/2610. database security (cont.)assignment 512/3course revision,and survey12/10final exam weekinstructor responsibilitiesas an instructor of this course, i am responsible for: posting lecture notes online in a timel

20、y manner responding to student concerns via email in a timely manner (within 24 hours usually if i am in town) logging in to webct daily to study new developments posting assignments and important announcements in a timely fashionstudent responsibilitiesas a student in this course, you are responsib

21、le for: managing your time and maintaining the discipline required to meet course requirements covering all readings, online and offline, in a timely manner adhering to course deadlines reading any e-mail sent by me and responding promptly logging in to webct at least once daily to study new develop

22、ments “i didnt know” or “i didnt look on website” is not an acceptable excuse for failing to meet the course requirements. if you fail to meet your responsibilities, you do so at your own risk.software required1. microsoft windows xp or higher and the ability to administer your own machine.2. micros

23、oft office 2003 or higher (students should ensure they have access to ms access 2003 or 2007)3. internet explorer 5.0 or higher or equivalent browser4. other software as needed for assignments and tests.other important items1. please cc to yourself any email that you need to be sure has reached me.

24、please note that i am unable to provide individual confirmation of receipt of your email sent to me.2. in webct, the “outbox” stores all sent emails, if they have been successfully sent. this feature is handy to use if you need to check whether any attachment was sent successfully to me via webct em

25、ail.academic dishonestyacademic dishonesty includes, but is not limited to, activities such as cheating and plagiarism (/advising/a.htm#academic dishonesty/academic misconduct). it is a basis for disciplinary action. any work turned in for individual credit must be entirely the

26、work of the student submitting the work. you may share ideas but submitting identical assignments (for example) will be considered cheating. you may discuss the material in the course and help one another with concepts; however, any work you hand in for a grade must be your own. a simple way to avoi

27、d inadvertent plagiarism is to talk about the assignments, but dont read each others work or write solutions together. for your own protection, keep old versions of assignments to establish ownership until after the assignment has been graded and returned to you. if you have any questions about this

28、, please contact me immediately. all work that is not your own must be properly cited. this includes any material found on the internet. stealing, giving or receiving any code, diagrams, drawings, text or designs from another person (csu or non-csu, including on the internet) is not allowed. having

29、access to another persons work on the computer system or giving access to your work to another person is not allowed. it is your responsibility to keep your work confidential. no cheating in any form will be tolerated. the penalty for the first occurrence of academic dishonesty is a grade of f in th

30、is course. other penalties include suspension from the computer science program at csu and/or dismissal from the program. all instances of cheating will be documented in writing in the university records. students will be expected to discuss the academic misconduct with the faculty member and the ch

31、airperson of the department.academic honesty is highly valued at columbus state university. you must always submit work that represents your own original ideas. if any programming or ideas are used that do not represent your original work, then you must cite all relevant sources. ideas that require

32、citations include, but are not limited to, all hardcopy or electronic publications, whether copyrighted or not, and all verbal or visual communication when the content of such communication clearly originates from an identifiable source. collaboration is not permitted on assignments or exams in this

33、 course, unless explicitly specified by the instructor. for exams, access to any type of written material or discussion of any kind (except with me) is not allowed. in addition to instructor-initiated penalties, there will also be university-initiated penalties and disciplinary action. academic dish

34、onesty could involve: having a tutor or friend complete a portion of your assignments. having a reviewer make extensive revisions to an assignment. copying work submitted by another student. using information from online information services without proper citation. getting help student assistants i

35、n the computer center (see /studenthelp/index.asp) can help you with basic computer-related problems such as logging on to the network, saving your work, etc., but they are not obligated to help you with your assignments. there are several tutors in the computer science depart

36、ment who may be able to help you with some course-related work. their schedule is posted in the computer science department and on the website . you can always contact me through email, fax, mail, in person during my posted office hours or by appointment. attendance it is your r

37、esponsibility to sign a roll sheet for every meeting in the classroom. at my discretion, i may drop you from the course for more than 3 physical absences. missing an exam is considered an absence. missed classes caused by participation in university-sponsored events will not count as absences provid

38、ed you notify me of such anticipated absences in advance. you are responsible for all class work missed, regardless of the reason for the absence(s). late assignments will not be accepted. no makeup exams will be given, so please make sure you are present for all exams and quizzes. refer to the csu

39、catalog (/advising/a.htm#absence%20policy) for more information on class attendance and withdrawal. student web space and email accountall currently enrolled students (including online students) can request free web server space on the csu student web server. simply go to http:/

40、 and click on the get free web pages icon. then click on the links to request the account. under normal circumstances, the account and space will be created in a matter of seconds. this server is also .net capable. as a csu student, you also have an email account with the form l

41、astname_. since most csu-related emails are sent to this account, please check it regularly or enable email forwarding to another account.website(s)it is your responsibility to frequently look at the course material on cougarview (webct vista) to keep your knowledge of class act

42、ivities current. i am not responsible for missed assignments or exams because you did not read an announcement regarding the deadlines. csus ada compliance statementif you have a documented disability as described by the rehabilitation act of 1973 (p.l. 933-112 section 504) and americans with disabilities act (ada) and would like to request academic and/or physical accommodations please contact joy norman at the office of disabil