Final Exam

Kulas, the administrator of Pitok University, wants to know who/how many students are experiencing the symptoms of COVID-19. The symptoms known so far are Fever, cough, sore throat, colds and many more.

He decided to form a group of programmers who are going to develop a survey app that is going to fulfill the above requirement. You are tasked to create the design for the backend database for the said app.

Sample data:
Kyra Nituda
- cough, sore throat
Jodessa Edades
- colds
Susan Lorenzo
- fever, cough, sore throat
Grace Basi-Basi
- colds
Jessie Bualat
- sore throat, fever
Lorlyn Camansi
- fever, sore throat, shortness of breath
Camille Dono
- no symptoms
Sylvia Aranas
- cough, colds, sore throat

Write/Draw your answer to a paper, take a picture of it then (pass) PM it to @pitokbatolata. I am going to accept your answers up to 3:00PM only. Good luck!

Your answers should resemble our last activities in which you are going to input the sample data in your database design.

Entity Relationship Diagram

ERD
 - Entity Relationship Diagram
 -  is a type of structural diagram for use in database design. An ERD contains different symbols and connectors that visualize two important information: The major entities within the system scope, and the inter-relationships among these entities.

Entity / Entities
 - tables
 - is a definable thing or concept within a system, such as a person/role (e.g. Student), object (e.g. Invoice), concept (e.g. Profile) or event (e.g. Transaction) (note: In ERD, the term "entity" is often used instead of "table", but they are the same). When determining entities, think of them as nouns.
 - symbol is a rectangle

Weak Entities
 - tables that are dependent to other tables
 - symbol is double lined rectangle

Attributes
 - columns
 - is a property or characteristic of the entity that holds it
 - symbol is oval/elliipse

Types of Attributes
 - Derived ex. Age from Birthday
- symbol is dashed ellipse
 - Multi-valued ex. tags in a tweet - double line
- symbol is double ellipse
 - Composite ex. Name from lastName + firstName

Relationship
 - A relationship between two entities signifies that the two entities are associated with each other somehow

Cardinality
 - defines the possible number of occurrences in one entity which is associated with the number of occurrences in another

One-to-One Cardinality
 - is mostly used to split an entity in two to provide information concisely and make it more understandable ex. user and userProfile

One-to-Many Cardinality
 - A one-to-many relationship refers to the relationship between two entities X and Y in which an instance of X may be linked to many instances of Y, but an instance of Y is linked to only one instance of X

Many-to-Many Cardinality
 - A many-to-many relationship refers to the relationship between two entities X and Y in which X may be linked to many instances of Y and vice versa

Cardinality Symbols:

More Readings:
https://www.tutorialspoint.com/dbms/er_diagram_representation.htm

Database Normalization

First Normal Form (1NF)
- A relation is in first normal form if and only if the domain of each attribute contains only atomic (indivisible) values, and the value of each attribute contains only a single value from that domain.

1NF Criteria:
- Eliminate repeating groups[clarification needed] in individual tables
- Create a separate table for each set of related data
- Identify each set of related data with a primary key

Second Normal Form (2NF)
A relation is in the second normal form if it fulfills the following two requirements:

- It is in first normal form.
- It does not have any non-prime attribute that is functionally dependent on any proper subset of any candidate key of the relation. A non-prime attribute of a relation is an attribute that is not a part of any candidate key of the relation.

* "There should be no partial dependency"

Third Normal Form (3NF)
- The entity is in second normal form.
- No non-prime (non-key) attribute is transitively dependent on any key i.e. no non-prime attribute depends on other non-prime attributes. All the non-prime attributes must depend only on the candidate keys.

* it should not have Transitive Dependency.


Additional readings:

https://www.studytonight.com/dbms/database-normalization.php
https://www.studytonight.com/dbms/first-normal-form.php
https://www.studytonight.com/dbms/second-normal-form.php
https://www.studytonight.com/dbms/third-normal-form.php

Activity 1-21-2020 Section B

* Create this user account:

Full Name : iJet Dono
username : ijet
password : 54321
user level : 10

1. Login using the user account ijet

2. Encode this user:

Full Name : John Paul Balaan
username  : jpaul
password  : 69
user level: 10

2. Encode this Product:

Name : Hentai Soy Sauce
Barcode : 666666
Brand : JP Hentai
Unit : Pouch
Category : Condiments
Supplier : Hentai Enterprises
Cost Price : 10.00
Selling Price : 15.00

3. Logout

4. Login using the account jpaul

Activity Section A

1. Alter the structure of tblProducts, add this column:
prod_encodedBy int

2. Modify the Products data entry and add a label "Encoded By" which will contain the full name of the user who encoded/updated that certain product.

Assignment For Section B

Create this table:

tblUsers
user_id AI
user_fullName Text(50)
user_username Text(20)
user_password Text(20)
user_level int

1. Create a data entry for the users table
2.  a. Create a login form. Make this as the startup form.
     b. If login is successful, display the full name of the user to the title bar of the dashboard.

Note: Create a default user in the database: 
     username: admin
     password: 12345

Project Proposal Outline

Project Proposal Outline

The project proposal is the key document in preparing for the project process. The project proposal  outline is essential in organizing the detailed research and in assisting the student in identifying the direction the research should take. The outline assists the project groups and the project advisers in keeping track of what has been accomplished and what are yet to complete.

The project proposal outline is divided into four sections: Introduction, Project Description, Project Management, and Appendix which will be discussed in detail in the succeeding section.

I. INTRODUCTION

1.1 Background of the problem

This should contain a discussion on the general problem to be addressed by the project work.

Quoted below is the general problem of the project, “Pahina:Educational Role Playing Game Based on Ancient Philippine Literature” from STI-Caloocan:

“The study of Ancient Literature in the Philippines is conceived by most as under the coverage of the learned and the patient. As a result, Philippine literature is considered as a course students have to inevitably pass, but rarely enjoyed. This seems to be such a waste of a great heritage…This heritage of

the Filipinos must be passed on to the next generation, to preserve our past.”

“Educational games are becoming a popular mode of learning for young children nowadays….As it is, most of these educational games in the market are geared for the young…Complexity of these games increases as the age of the child increases. That is also the reason why educational games targeted for the older set of adolescents to the young adults are rarely developed.”

“Presented with these developments, the proponents intend to propose to develop a game based on the characters and events found in the various literatures of ancient Philippines to interest the college students of STI Caloocan and provide them a means to connect with their own past.”

1.2 Overview of the Current State of the Technology

This should contain the current solutions being implemented and the problems with each of these. The discussion could either be in chronological or logical order. This should include only enough details to show the specific improvements introduced by each. This should lead to the specific problem that the proponents intend to address. The information regarding the technology or field should be contemporary and not based on outdated sources.

1.3 Project Rationale

This should point out how finding a solution to the specific problem is beneficial. Your purpose for this section is to convince the audience that the project is worth pursuing.

II. PROJECT DESCRIPTION
This is the most important part of the project proposal. Completion of the project will be based on the contents of this section.

2.1 Problem Statement
This could be either in question form or as a declarative statement. The major statement or question may be followed by minor statements or questions. This attempt to focus on a stated goal gives direction to the research process. It must be limited enough in scope to make a definite conclusion possible.

Furthermore, this is identified by answering the question: What is being solved by this research or project?

2.1.1 Specific Problems
     * Specific Problem 1
          - Explanation
     * Specific Problem 2
          - Explanation
     * Specific Problem n
          - Explanation

Proposed Research Project

2.2.1 General Objectives

This should contain a single paragraph describing the general objective of the project. It should state the overall goal that must be achieved to answer the problem.

Specific Objectives

This should contain a list of the specific work that the proponents expect to address to arrive at the
accomplishment of the general objective. The objectives must be specific, measurable, attainable,
realistic, and time-bounded (SMART).

Specific objectives from “Pahina:”

• “To create 3D sprites of terrains and objects”
To create 3D models for the characters, terrain, and other objects using 3D modeling software primarily 3D Studio Max, an application that employs its own 3D graphics engine, rendering engine, and applies the concept of 3 point coordinates known as vertices, simulation of lighting effects, and texture effects.

• “To be able to create tools which would be capable of manipulating and integrating graphics,
sounds, and inputs”
The proponents need to create tools that would harmoniously integrate the graphics, sounds, and
inputs such as graphics engine, map editor, scripting engine, etc. by the use of Visual Basic 6
and Microsoft DirectX Libraries.

2.2.3 Scope and Limitations

This should contain the basic assumptions within which the project should work the solution to the problem. Consequently, this should also contain the extent of the prototype to be developed and the
means by which the proposed system is to be evaluated on its capability of solving the problem.

The limitations are those conditions beyond the control of the proponents that may place restrictions
on the conclusions of the study and their application to other situations. In other words, this section discusses the boundaries of the research

2.2.4 Methodology

This should contain the specific approaches that may be employed by the proponents in arriving at the
realization of a solution to the problem. Note: There will be a separate discussion on the methods of research.

The methodology should include the following information:
_ The person responsible for the task
_ The resource person to be contacted
_ The type of methodology to be used
_ The date and time in which the activity should take place
_ The place where the activity was conducted
_ The reason for doing the activity

III. PROJECT MANAGEMENT

3.1 Calendar of Activities

3.1.1 Description of Activities

This should contain the detailed sequence of activities that the proponents will undergo in completing the project.

Quoted from the project, “On-Line CHED Scholarship Monitoring with Inquiry Via Mobile Technology”:

The following are the tasks to be accomplished by the group to complete the project.

1. Data Gathering

“One of the most important factors of building the system is gathering of information…. The whole month of June will be allotted for data gathering which includes interview with key people from CHED, internet research, and library research.”

“The proponents will conduct an interview with Ms. Elena S. Jane, CHED Scholarship Coordinator. The information gathered from the interview will be used to assess the problems encountered by the department in monitoring the scholarship program.”

“Moreover, the proponents will use the Internet to research about the World Wide Web, transaction
processing system, and the implementation of WAP.”

2. Software Requirements Analysis

By July, the proponents will now analyze the different software requirements which they need in the
development of the monitoring system via mobile technology.

3.1.2 Gantt Chart of Activities

This should contain a chart that shows when each of the activities listed above are expected to start and end. The time unit should be in terms of the week number (not actual dates) per month from the start of the semester up to the time of defense (please count the approximate number of weeks).

3.2 Resources

3.2.1 Hardware
This should list the specific hardware resources that the proponents expect to need in completing the project and how they plan to acquire or access the necessary equipment/instruments.

3.2.2 Software
This should list the specific software resources that the proponents expect to need in completing the project.

IV. APPENDIX
4.1 Resource Person/s
For each resource person, specify the following information:

<Full name and title, e.g. Dr. Lorlyn X. Estrada>
<Profession, e.g., Faculty>
<Department, e.g., Information Technology Department>
<Name of Institution, e.g., PHINMA Cagayan de Oro College>
<E-mail address/Contact numbers, e.g., lorlyn@gmail.com 0916-666-6666>

4.2 Personal Technical Vitae
For each proponent, specify the following items:
<Full name, e.g., Susan Lorenzo>
<Address, e.g., 269 Kauwagan, Cagayan de Oro City>
<cellular phone nos. e.g., 0981-8711622>
<e-mail address, e.g., susan@outlook.net>

Assignment Section B

Create this table:

tblUsers
user_id AI
user_fullName Text(50)
user_username Text(20)
user_password Text(20)
user_level int

1. Create a data entry for the users table
2. Create a login form using the users inputted in the users table. Make the login form as the startup form.

How to pass data from one form to another:

https://www.c-sharpcorner.com/UploadFile/834980/how-to-pass-data-from-one-form-to-other-form-in-windows-form/

In your login form (fmrLogin), initialize a public static variable for the user's full name. Assign a value to the variable when the user clicks Login Button:
 

Access that variable from your dashboard/main form and assign it as the title of the form

Assignment

Create a data entry for each of the following table:

Database Name: dbInventory

tblProducts
prod_id auto
prod_name text(50)
prod_barcode text(20)
prod_brand int
prod_unit int
prod_category int
prod_supplier int
prod_costPrice currency
prod_sellingPrice currency

tblBrands
brand_id auto
brand_name text(50)

tblUnit
unit_id auto
unit_name text(50)

tblCategory
cat_id auto
cat_name text(50)

tblSupplier
sup_id auto
sup_name text(50)
sup_address text(50)
sup_contactPerson text(50)
sup_contactNumber text(500)

Brands, Unit, CAtegory and Supplier are all lookup tables

Incremental Search

Messagebox

This method is going to be fired when the content of the search box changes or when the user types in the search box

This method is going to fetch all records that matches the search code using the LIKE operator and displays them into the listview