CCS 2600 Software Development Title Defense Structure

The following will be the content of the presentation during the Title Defense of your proposed System Development in CCS 2600: Programming with Databases:

I. Title
II. Introduction
 - This section will discuss the current state of technology that the clients' currently employ, whether it is done manually or with few technologies. Usually in paragraph form, and short and concise.
III. Statement of the Problems
 - This section will identify the problems encountered by the client using the current state of teachnology. (In bullets)
III. General Objective
 - The overall goal of the development process. (Ex. To create the Inventory System for Jing Jing's Sari-sari Store)
IV. Specific Objectives
 - This elaborates the general objectives and states the specific steps to accomplish it. These must be specific, measurable, attainable, realistic. Usually divided by the scope and thus defines the main modules in the system. (Ex. In an inventory system, the modules will be adding products, stock in and point of sale. Thus, one specific objective will be To create a Point of Sale module that manage the sales of the system.) Avoid the technicalities such as To pass the subject CCS 2600. (Numbered, ordered by process what comes first and must answer each statement of the problem)
V. Significance of the Study
- This section explains why research must be done in this area and what are the benefits.
VI. Members and Roles. (Team Leader first then others alphabetical)

Good luck!

(Source: Modified Capstone Format)

Chapter 3 and 4 of Fundamentals of Database Design

The following are the links for the presentations on The Fundamentals of Database Design:

Chapter 3 - Relational Model

Chapter 4 - ERD

Or you could check out my SkyDrive for additional references.

Case Study #2: Bautista - De Leon Law Firm

You may download a copy of the second case study via the following link: Case Study #2: Bautista - De Leon Law Firm (Link: http://sdrv.ms/11tL4xU)

Or, you may  copy the content below.
*******************************************************************************

Case Study # 2: Bautista – De Leon Law Firm

The Bautista-De Leon Law firm has been an authority when it comes to handling cases that are sensitive as their main clients are celebrities and politicians. The lawyers under the firm are:

1.      John B. Bautista, ID: 10001,  57 years old, Male

2.      Ross G. De Leon, 10002, 47, F

3.      Raymond M. Dela Cruz, 90562, 25, M

4.      Sarah M. Pena, 56734, 45, F

5.      Jason K. Arioles, 23415, 24, M

6.      Roberto S. Juan, 34126, 45, M

7.      Morrie H. Jover, 90345, 29, M

8.      Jenn Y. Yu, 10006, 35, F

9.      Michelle K. De Leon, 10008, 27,F

For the last few months, Bautista-De Leon had few high profile clients:

1.      Nancy B. Benay, a politician, had asked for political advises from Atty. Dela Cruz and Atty. Pena.

2.      After the election, Mrs. Benay had then asked for Atty. Ross De Leon for regular advice.

3.      Krissy M. Akino, a celebrity, had filed for annulment with James A. Yup with the assistance of Atty. Bautista

4.      Pinky K. De Lion, another celebrity requested a draft for prenuptial agreement with her Fiance, Jake H. Keunca, with Atty. Pena’s assistance.

5.      Mr. Kuenca, on the other hand, had Atty. Arioles’ representation

6.      Pinoy M. Akino, a politician and Krissy’s brother has asked for Atty. Yu’s advice.

7.      Fanny K. Locson, a politician, had been accused of murder. He had sought help from Atty. Juan as Mr. Locson allegedly had been set up.

The firm had always internally classified their cases under three classes: Class A, for celebrity cases; Class B, for cases associated with politics; Class X, for criminal cases; and Class O, for those uncategorized.

Create a database that would record all the transactions in the firm. Then, create a query that would show all the transaction made and 4 queries, each showing cases categorized per classes.

NOTE that there is no need account the earnings of the firm.

DB: Bautista_DeLeon_<your lastname>

Criteria for Scoring:

Proper Database Structure

               Tables

                              Naming Conventions                      15 pts

                              Content                                             10 pts

               Relationship                                                     5 pts

Query

               Transaction                                                      5 pts

               Query per Class                                               10 pts

Mechanics                                                                       5 pts__ 

Total                                                                                 50 pts

Prepared by:

Mr. Rodolfo C. Eregia, Jr.

*******************************************************************************

You may also visit my SkyDrive account for updates on more notes and references. (Link: http://sdrv.ms/18AUHgJ)

Case Study 1: Book ReSale, Inc Transactions

Case Study 1: Book ReSale, Inc System

Mr. John Delgado decided to put up a business on retailing books that are both brand new and already used with the markup of only 10%. So, after renting a spot in a known mall, he started advertising his proposed business to prospected suppliers and clients to great results.

1.      Janet De Castro had a used book, The Devil’s Advocate by Evan Goodling, in good condition sold to Book ReSale for Php 300.50

2.      Clark Henares sells 5 copies of The Notebook by Nicholas Sparks all in good condition for Php 150.00 each

3.      Rubeth Palacios sells her collection of the Percy Jackson series (The Lightning Thief, The Sea of Monsters, The Titan’s Curse, The Battle of the Labyrinth, The Last Olympian) by Rick Riordan for Php 250.00 each, all of whom are in good condition.

4.      Michael de la Cruz sells his copy of The Titan’s Curse for Php 50.00 only as it was in bad condition.

5.      HarperCollins supplies the following brand new books with their corresponding prices and copies:

          1.      The Hunger Games by Suzzane Collins, 350.00, 7

          2.      Catching Fire by Suzzane Collins, 350.00, 7

          3.      Mockingjay by Suzzane Collins, 350.00, 7

          4.      Divergent by Veronica Roth, 400.00,  5

          5.      Insurgent by Veronica Roth, 400.00, 5

          6.      American Gods by Neil Gaiman, 250.00, 3

          7.      The Graveyard Book by Neil Gaiman, 250.00, 3

6.      VisPrint also supplies the following books:

          1.      ABNKKBSNPLAKo by Bob Ong, 100.00, 5

          2.      Bakit Baliktad Magbasa by Bob Ong, 100.00, 5

          3.      Stainless Longganisa by Bob Ong, 150.00, 5

7.      Bryan Guevara bought a copy of Mockingjay. Since he was the first customer, Mr. Delgado gave him a 5% discount.

8.      Jesse Mitchell buys the two copies of The Titan’s Curse.

Assume that you were hired to be a data processing specialist, create a database model for Book ReSale based on the collected data above.

NOTE: In this case study, do NOT take note of the Inventory of Books and the Accounting of Sales. Simply record the transactions in the database.

Solution(in MS Access 2007)(Note: click the smaller download link, not the big one in the ads):

http://www.2shared.com/file/fCqlSGrk/Case_1.html

CCS 2100 Presentations

The following are the links for the first two presentations in our lesson on Fundamentals of Database Design (Note: click the smaller download link, not the big one in the ads):


Chapter 1
http://www.2shared.com/document/QX5YMz7y/9780538469685_PPT_ch01.html

Chapter 2
http://www.2shared.com/document/yIJ0c07_/9780538469685_PPT_ch02.html


Remember that this is only for this time. No notes will be given after the prelim exams.

Comp 310 Presentations

The following are the links to the copy of the presentation to be discussed in COMP 310 subjects. (Note: click the smaller download link, not the big one in the ads):

Chapter 1 - Introduction to Computers
URL: http://www.2shared.com/file/v8TyhDwr/chapter01-110612081731-phpapp0.html

Chapter 2 - Fundamentals of the Internet
URL: http://www.2shared.com/file/G-a73fFD/chapter02-110612080629-phpapp0.html

Please share with your classmates.

Graphs

The following is the link to the sample program demonstrating how Graphs works. (Note: click the smaller download link, not the big one in the ads):

Graphs
http://www.2shared.com/file/6--Tz48f/Graph.html

Mock Final Laboratory Exam Sample for Data Structures and Algorithm

The following is the link to the copy of mock test given in preparation for the final exams next week. (Note: click the smaller download link, not the big one in the ads):

Mock Programming Test
URL: http://www.2shared.com/file/3_e-C8Gg/Mock_Test.html

It contains the following:
      1. Abstract classes of the data structures' Array-Based Lists, Linked Lists, Stacks and Queues
      2. Sample programs of the said data structures as well as that of Recursion
      3. Sample test with instructions.

Note of the following laboratory exam schedules for the CCS 1300 S.Y. 2012-2013:
      1826 - March 15
      1827 - March 13
      1829 - March 19
      1830 - March 14

These will be during your laboratory schedule. Admittance only for those who arrive 15 minutes after the time.

Good luck!

Functions and Classes in C++

Here is the sample application of Functions and Classes in c++.

Things to note:

1.      Identify the object or class

2.      Identify its properties

3.      Identify its functions: usually they are the following:

a.      Function of each input

b.      Function for calculations and display

4.      Then, define and order them in the program

Click the jump for an example.

Recursion Sample

The following is the link to the sample program demonstrating how Recursion works. (Note: click the smaller download link, not the big one in the ads):

Recursion
URL: http://www.2shared.com/file/MNHpIMfO/Recursion.html

Queues Example

The following is the link to the sample program demonstrating how queues work. (Note: click the smaller download link, not the big one in the ads):

Queues
http://www.2shared.com/file/XC5kxDuv/Queues.html

Heap Sort in Details

The following is the link to the document that shows the Heap Sort and how they work. (Note: click the smaller download link, not the big one in the ads):

Heap Sort
URL: http://www.2shared.com/file/CQtj69eE/hepsort.html

Stacks Example

The following is the link to a copy of a list using the stacks structure or better known as the Last In First Out.(Note: click the smaller download link, not the big one in the ads):

Stacks
URL: http://www.2shared.com/file/hlDfwyef/Stacks.html

Updated Order of Lecture Topics for CCS 1300

The following is the updated order of the lecture topics to be followed in CCS 1300: Data Structures and Algorithm. Please take note of the changes in preparation for the prefinal exams.

LECTURE TOPICS 

PRELIM

I.       Software Engineering Principles and Java Classes

1.     Software Life Cycle

2.     Software Development Phase

3.     Algorithm Analysis: The Big-O Notation

4.     User Defined Classes

5.     Abstract data types

II.     Inheritance and Exception Handling

1.     Inheritance

2.     Abstract Methods and Classes

3.     Composition

4.     Exception Handling

Quicksort atbp

Just wanted to share a very nice video on how Quicksort algorithm works.

The user also has more useful videos showing examples with other algorithm. Thanks Think Aloud Academy! Enjoy!

CCS 1200 Notes

Here is the link for the book that we are currently using in CCS 1200: Object-Oriented Programming Using C++.  (Note: click the smaller download link, not the big one in the ads):

Object-Oriented Programming Using C++ 4th Ed. by Joyce Farrell
URL: http://www.2shared.com/document/s267veZe/Object-Oriented_Programming_Us.html

Remember that this is just a reference and this is not the official textbook for the course.

Linked Lists Example

The following is the link for the complete sample program of an integer list that use Link lists data structure. (Note: click the smaller download link, not the big one in the ads):

Linked Lists
http://www.2shared.com/file/wXvYA1aw/Linked.html

The file is in ZIP format. Simply extract it to access the codes.

Or you may encode the following 5 java classes:

---------------------------------TestProg_Linked.java-----------------------

import java.io.*;

import java.util.*;

public class TestProg_Linked

{

    static BufferedReader keyboard = new

           BufferedReader(new InputStreamReader(System.in));

Array-Based Lists Example

The following is the link for the complete sample program of an integer list that use array-based data structure. (Note: click the smaller download link, not the big one in the ads):

Array-Based List
URL: http://www.2shared.com/file/pA8UVyql/1_-_Array_Based.html

The file is in ZIP format. Simply extract it to access the codes.

Or you may encode the following 5 java classes:

------------------------TestProg_Array.java------------------------

//Test Program Integer Array List
import java.io.*;
import java.util.*;

public class TestProg_Array
{
    static BufferedReader keyboard = new
           BufferedReader(new InputStreamReader(System.in));

    public static void main(String[] args) throws IOException
    {
        UnorderedArrayList intList = new UnorderedArrayList(50);
        IntElement num = new IntElement();