| Week | Information |
|---|---|
| Assignments due in one week unless otherwise stated. I may add some things during the week, so double check the schedule each week! | |
| Web Huddle Meetings |
|
| Week #15 Notes and Assignments | Please contact me when you are ready for the final. |
| Week #14 Notes and Assignments | I will be available for help on Tuesday at 2:00, Thursday at 12:00 (CIS50
has priority, 2:00 (CIS44 has priority), Friday from 9:00 to 11:00 (CIS17 has priority),
12:00 (CIS50 has priority) and 1:00 until 3:00. Help sessions will be in K101. If there
is a problem with the room booking at any point, I will be available in K130 or you can
find me in my office. I can do a WebHuddle meeting Sunday, December 11th at 6:00 if that works for you. (Cancelled the Sat since others had conflicts.( Please review the Holt Distributors example and the Alexamara Marina example at the back of your text book. Here are some notes from a class where I discussed the Diary project with the class: Dairy notes Dairy notes from review Notes on dairy flow Assignments: Please do exercise 1 (a-i) on page 355 of your text. The final will be posted so that you have a week to do it. |
| Week #13 Notes and Assignments | I am home sick today, so a webhuddle meeting this evening (Monday, Nov 28th) at 7:00 would work well for me. Let
me know if it works for you. Please read chapter #9 in you text book. Check back! Assignments: I want you to go over the Design Example for Marvel College in appendix A very carefully and make sure you understand the example. I will ask some questions about this either next week or on the final. |
| Week #12 Notes and Assignments | Please read chapter #8 in your text book. Please check your postings at Mayetic Village for responses from me - I am posting comments this week - you should incorporate my suggestions into the assignment as you resubmit it. under presentations at this site. I have cancelled the meeting for Wednesday - it was a problem! Assignments: Please answer question #3 on page 260 in your text. "Use computer magazines or the Internet to investigate one of the DBMSs: DB2, SQL Server, MySQL, Oracle, or Sybase. Then prepare a report that explains how that DMS handles the following DBMS functions: concurrent update, data recovery, and security. (Note: For concurrent update, you might need to review the concurrency control features of the DBMS.)" Continue working on the Bristol Dairy. |
| Week #11 Notes and Assignments | I have been sick this week and going to bed early so I have not been able to set up a WebHuddle.
I am willing to do one this weekend (Saturday, 11/19 at 7:00 would work for me). Please let me know
if this works or if another time would work better. I want to go over the information related
to the Bristol Dairy. We are getting to the point where I am putting up comments that amount to answers on the Village. If you have not participated in the discussions, then you need to contact me about different assignments to complete this course. Advisement starts this week. I will be available for online advisement on Monday from 10 to 1. We can email back and forth using pgrocer@comcast.net for advisement purposes. I will also be available to do advising on Wednesday, Novemeber 9th via email at pgrocer@comcast.net. I can advise you and give you your pin so you are ready on Monday. I do not have transcripts at home so you are responsible for telling me what you have taken! Other advisement times will be posted on my door on Wednesday, November 9th. Please read chapter #7 on DBMS Functions. I will ask a question related to it next week. Please look at the presentation on the Systems Development Life Cycle listed under presentations at this site. Assignments: Bristol Dairy Assignment |
| Week #10 Notes and Assignments | I am going to a conference and then away for the long weekend, so I am not sure I will be home any evening this week in time to do a meeting, if things change
I will post. I have had a change in plans and I could do a meeting at 7:00 on Wednesday, Nov 8th for
about a half an hour on ER etc. Let me know if you want to participate - I will set it up
either way and if nobody comes, that is fine! Please look at the presentation on relational theory and ER which goes into more detail on using a version of ER diagrams. Assignments: Please do some research and read about entity-relationship diagrams. Please send me comments on two articles you have read. Catering database As usual, I have put this assignment out on Mayetic Village. Let me know whether this helps or not. The participation has gone down so I am questioning the value! I am also getting concerned! Let me know if there is a problem! 11/17/05: We are getting to the point where I am putting up comments that amount to answers on the Village. If you have not participated in the discussions, then you need to contact me about different assignments to complete this course. |
| Week #9 Notes and Assignments | This is not my week with technology! We ran into problems with WebHuddle on 11/1. I talked
to the developer and he is working on the problem long term - but says things are up and running
and he feels it is worth trying, so 7:00 on 11/2).
I had a problem with my email and lost everything from 10/23/05 through 10/31/05. If you sent
me something during that period, you need to resend. I am working on recovery, but I do not know
when! For safety, you can send a copy to pgrocer@comcast.net if you want to! This week we are going to continue to discuss relational database development and entity-relation diagrams. Please look at the following handout - we will discuss it on WebHuddle. Medical clinic (basic model) Assignments: Please post at Mayetic Village. I am getting concerned because I am not seeing enough design postings. Also, when you are ready for me to grade you must send me your answer to the assignment to grade! Insurance Design Assignment The assignment has been posted at Mayetic Village. Please post your design thoughts and comments. You can start with just relating two or three tables and then expand or let others expand. 11/17/05: We are getting to the point where I am putting up comments that amount to answers on the Village. If you have not participated in the discussions, then you need to contact me about different assignments to complete this course. |
| Week #8 Notes and Assignments | We need to get more discussion going on the projects that have been posted at Mayetic Village. I
did not respond for a while because I was waiting for others to join, but my responses are there
now! This week I would like you to read chapter #6 in the text. I would also like you to look at the Presentation on entity relationship diagrams at the class site (be sure you have looked at all the presentations under Introductory/Definitions). Continue looking at the presentations under Examples. I think the University of Texas at Austin has a set of articles on Data Modeling and Relational Modeling worth reading. I would like you to start reading these articles. You will find them at: Introduction to Data Modeling and Relational Modeling I want you to read this writup: Database Design Principles Assignments: Doctor Entity-Relationship assignment - this is an individual assignment and was not posted for discussion Student assignment including entity-relationship and tables This has been posted on Mayetic Villiage for discussion. Again remember that part of your grade is discussion. If you just do the assignments and pass them in you will only get partial credit. Everyone must pass in their version of the assignment, but only those that do so after participating in the discussion will get full credit! 11/17/05: We are getting to the point where I am putting up comments that amount to answers on the Village. If you have not participated in the discussions, then you need to contact me about different assignments to complete this course. |
| Week #7 Notes and Assignments | The discussion on Mayetic Village for the chapter #5 problems is now closed to people who
have not participated prior to 10/16/05 and so that assignment cannot be done by the people
who did not join. You can still join the Credit Union discussion. I have extended the discussion
of the credit union for another week because I would like to get some responses to my comments.
Will now close on 10/30/05. I have also posted some responses on
chapter #5 that your should review. The three people who have contributed are invited to continue the discussion. The webhuddle for this week will deal with these problems and questions about the next design. This class really requires participation in the design discussions. Extra credit projects will be available later on in the semester. Please look at the PowerPoint presentations on job applicant database and contractor database. I actually discussed them in last weeks WebHuddle meeting. I would also like you to look at the other PowerPoint presentations under examples. These are very basic examples of normalization and database development. Assignments: I want you to read three articles on relational databases and normalization and report back. Tell me the article you read, what it was about and whether or not it was helpful (I would like this in word). There are a variety of links at my site under links and tutorials. Pedigree Dog Store (due in 2 weeks) I ended up putting the assignment on Mayetic Village because of expressed interest. Since I said you can do it individually, the offer still holds - however extra credit if you participate in the discussion at the Village. 11/17/05: We are getting to the point where I am putting up comments that amount to answers on the Village. If you have not participated in the discussions, then you need to contact me about different assignments to complete this course. |
| Week #6 Notes and Assignments | Check the list of WebHuddle meetings at the top - hopefully everyone can get on if
they want to! I have written to the developer for some help with the problems. Please go to Mayetic Village and enter the discussion. I will extend through this week, but then I want your design sent to me and those who have participated will get credit for the degree of participation. I get messages in Mayetic Village saying it cannot process etc, but if I just click through things work - try different browsers if you have a problem. I am using Mozilla most of the time. Assignments: Credit Union database assignment I have but this assignment out on Mayetic Village as well. I would like you to post your ideas and discuss the solution. Again, each person must submit a solution. You can submit a solution developed by the group or your own solution but to get full credit for your own solution it must have been submitted as an idea to the group discussion. Remember you only need to layout the design - you do not need to implement in Access. 11/17/05: We are getting to the point where I am putting up comments that amount to answers on the Village. If you have not participated in the discussions, then you need to contact me about different assignments to complete this course. |
| Week #5 Notes and Assignments | I am listing the optional web meetings above. You are invited to join us. I want you to spend some time trying to understand Relational Databases and Normalization and the information in chapter #5. To help you to do this, I want you to look at the following presentations: Normalization - information on third normal form Separate speaker notes to accompany normalization presentation Relational database using donor Separate speaker notes to accompany relational databse using donors presentation Presentation on relational models - definitions Separate speaker notes to accompany relational models - definitions Presentation on normalization Separate speaker notes to accompany normalization I also want you to look at the following examples: Student database example Payroll database example Assignments: Using Access, I want you to create the Student and Payroll database described above. Please populate both with data. Continue working on the examples at Mayetic Village - I would like you to finish your design by next week. |
| Week #4 Notes and Assignments | Look at the Presentations about Access to help you understand the basic concepts. At some point, I would like you to read chapter #4 which is about Access and play with some of the concepts. However, this is a design course so I want you to read chapter #5. We will focus on the concepts covered in this chapter for a while. Last week, the students that were left at the end of WebHuddle agreed to meet this Tuesday (Sept 27th) at 6:30. I have to stay a little late at school, so I am afraid I may not be home quite by then so I would like to start the meeting at 7:00. We will use the same login. As always, you should check back! Assignments: I have sent you an invitation to join a group called cis39 that I have set up at Mayetic Village. I have posted 3 problems there that I want you to collaborate on as a class. You can then send me the solution that is developed, or if you disagree you can send me your own solution as long as you posted it as a suggestion at Mayetic Village. You will get two grades for this assignment: one is for your answers and one is for your participation in the collaborative effort. |
| Week #3 Notes and Assignments | This week I would like you to read chapter #3. I am going to do a Web Huddle meeting at
about 6:30 on Monday - please join me if you can. If this time does not work out, we can try a different
time next week. Go to www.webhuddle.com. Send me an email asking for login information.
If you have any trouble, email me around 6:30 - I will keep checking my email. Also check back here - I
will post any problems that occur. I am tentatively scheduling another webhuddle meeting for 6:30 on Tues the 27th. However, please let me know if that is OK if you are interested in participating. If you are not interested, please let me know that as well. Remember the meetings are total optional, they are designed as a supplement. Assignments: At the end of chapter #3 there are a lot of examples. I want you to do something similiar to each example using the Donor database you created. The examples you should follow are on page 98 forward and are #2 thru #20. Also do an example where you want condition 1 and either condition 2 or condition 3 to be true. |
| Week #2 Notes and Assignments | This week I would like you to read chapter#2. This is not a course for implementing
databases, it is a design course. But some understanding of how to set up a practical database
and how to query in SQL will be helpful if you decide to model one of your projects. So, to
that end, I want you to set up a simple database in Access. I am choosing Access because it
is readily available. If you do not have it, I can arrange for you to get the email with
instructions on downloading a free copy through the MSN Alliannce that the college belongs to.
We will take a look at this during the class meeting on Monday or over the web. I want to use
WebHuddle (www.webhuddle.com) to set up some on line interactive sessions (optional). I will set up a meeting on line that
you can choose to join. At the session, I can show and explain and also take questions. For information about software for this course: MSDN Alliance Software Assignments: First: Please send me an email telling me why you are taking this course and what you need/expect to get out of it. Also tell me when you are available for online interactive sessions. Give me lots of choices so I can try to coordinate all of our schedules - days, evenings, weekends - whatever works. Second: Download the student files to accompany the textbook. They are located at: Textbook Open the Access Premiere products database and study the implementation. Third:Using this presentation, create a donor database in Access. The presentation does not deal with Access, you can find tutorials under links at this site. Scroll down until you find Access. If you need an Access book, I can find an introductory one for you to borrow. Normalization - information on third normal form Separate speaker notes for normalization presentation |
| Week #1 Notes and Assignments | I recommend that you start this course now rather than waiting until next Monday.
This will give you more flexibility as the semester goes on. The first thing you should do is familiarize your self with the site. I will send you each an email at the address given at the school. You need to respond so I know you received it! If you have the book, please read chapter #1 (if you do not have it, read it when you get it!) Concepts of Database Management by Pratt, Adamski (5th ed) Information about the book and support products can be found at: Concepts of Database Management The recommended book is far more technical and has a lot of supplementary information for students who want to delve deeper into the area than we will go in this course. It is in the library, so you might take a look at it before making a decision about buying. I want you to read some introductory material from the web: This is a nice introductory series I want you to read the first two parts (you can go on if you find it interesting) Assignments: Because you may not have the book, this quiz is a learning quiz - keep taking it until you get 100! Send me an email when I should look at your quiz and enter the grade. Quiz |