1nf 2nf 3nf with example pdf

Oracle SQL Project

Instructions and Rubric of Individual Project CSCI 6623.81 / CSCI 3268.21 Database Systems

Due on November 12, 2020 at 10:00 AM (Presentation) Due on November 12, 2020 at 11:59 PM (Project Report)

Total Points: 100

Learning Objective: The individual project will provide you an opportunity to demonstrate and develop your understanding of the applied and research aspect of database systems in research domain.

The major learning objectives are: • How to identify a small problem in a research domain. • How to find requirements, design (ERD) and implementation (Oracle SQL) of a

problem in a research domain. • How to analyze and discuss the results of a research problem.

Requirements & Submission: 1. You will have to submit a five-page individual project report and a ppts (10

minutes presentation) based on this report. 2. Five-page individual project report must include two-page summary of an

assigned research paper, implementation of small module or design of database from assigned research paper, its Oracle SQL code, and screen shot of output.

3. Summary of research paper must include following topics. (a) Problem statements of the research article. (b) Background or literature survey or related work of research article (c) Solution statement or proposed work mentioned in the research article. (d) Results and discussion mentioned in the research article. (e) Conclusion and most important reference numbers mentioned in the

research article. 4. The design and implementation of small module of a database from the assigned

research article must include: (a) The description and requirements of selected module from assigned

research article. (b) The details of hardware (your machine) and software (must include

versions) used in your project. (c) Requirements and ERD (Crow’s foot model) of selected database from

research paper. (d) You need to include Oracle SQL code as an appendix in this report. (e) The screen shots of result of Oracle SQL code must be included in this

report. (f) The brief discussion needs to be included in this report based on your

results.

(g) You will have to submit *.SQL code of the project as an appendix. However, the appendix will not be counted in the number of pages of “Project Report”. It implies that appendix is considered additional number of pages in the project report. Additionally, there is no restriction of number of pages for the appendix.

(h) The internal documentation (i.e. comments) is required in Oracle SQL code. It means that you will have to mention that what are the purposes of a block of Oracle SQL code.

5. The format of individual project report must follow following specifications. Font: Helvetica, Font size: 12, single line inter-line spacing, page-setup: 1in all sides. Also, you have to include front page as per given guidelines. The sample of front page is available on blackboard. The front page will not be counted in 5- page individual project report.

6. You need to make a ppts for 10 minutes based on your project report. Also, you will have to present this ppts in the class. The presentation schedule will be announced on blackboard.

7. You will have to email (avatsa@fdu.edu) your ppts at least 15-minute before the presentation start.

8. Graduate Students: (a) Graduate students will have to submit 7-page project report instead of 5-

page report. It includes five-page report similar to undergraduate student’s report and additional two-page includes the summary of research paper from another research paper. The second paper you may choose from references of assigned research paper.

(b) You need to make ppts presentation from assigned research paper only. Also, you will have to consider only assigned research paper for individual project and presentation.

Grading Rubrics (A) (5+5+5+5+20+5+5 = 50 Points) Written Report & Technical Content:

• (5 Points) Maximum five pages individual project report as per given guidelines. (Font: Helvetica, Font size: 12, single line inter-line spacing, page-setup: 1in all sides. Also, you have to include front page as per given guidelines).

• (5 points) There should not be grammatical/punctuation/writing errors. Also, adequately followed all directions, requirements, pages, and paragraphs are well organized as per given instructions.

• You must include following topics in the summary: ▪ (5 Points) Problem statements of the research article. ▪ (5 Points) Background or literature survey or related work of research

article ▪ (20 Points) Solution statement or proposed work mentioned in the research

article. And, requirements, ERD, SQL code, and results of selected problem from research paper.

▪ (5 Points) Results and discussion mentioned in the research article.

▪ (5 Points Conclusion and most important reference numbers mentioned in the research article. References are mentioned using correct APA style.

(B) (5+5+5+5+5 = 25 points) Presentation Slides - PPTs: You need to cover following points in ppts.

• (5 points) Problem statements of the research article. • (5 points) Solution statement or proposed work the research article. • (5 points) Results and discussion the research article and your

requirements, ERD, and results of SQL code. • (5 points) References are mentioned using correct APA style. • (5 points) Organization of slides

(C) (5+5+5+5+5 = 25 points) Ten-minute Oral Presentation in the class. • (5 points) Duration of presentation (1 point / 2-minute) • (5 points) Preparation of Contents of presentation • (5 points) Explanation and discussion of the contents • (5 points) Talk organization • (5 points) Q & A.

Graduate Students (D) (10+5+5+15+10+5 = 50 Points) Written Report & Technical Content:

Summary of Research Paper-2 • (5 Points) Additional two-page summary of second research paper as per

given guidelines. (Font: Helvetica, Font size: 12, single line inter-line spacing, page-setup: 1in all sides.)

• (5 points) There should not be grammatical/punctuation/writing errors. Also, adequately followed all directions, requirements, pages, and paragraphs are well organized as per given instructions.

• You must include following topics in the summary: ▪ (5 Points) Problem statements of the second research article. ▪ (5 Points) Background or literature survey or related work of second

research article ▪ (15 Points) Solution statement or proposed work mentioned in the second

research article. ▪ (10 Points) Results and discussion mentioned in the second research

article. ▪ (5 Points Conclusion and most important reference numbers mentioned in

the second research article.

Policy on Lateness • 1 day late: 10% less of your secured points. • 2 days late: 20% less of your secured points. • 3 days late: 40% less of your secured points. • 4 days late: 60% less of your secured points. • 5 days late: 80% less of your secured points. • 1 week late: 0 points.