ISTE 230 – Introduction to Database and Data
Modeling
Fall 2023
Project
Submission: Nov 24 – Nov 26, 2023
ISTE 230 Project
Mission
In this project, you will go through the database development lifecycle phases to implement a database
for a business scenario of your own choosing.
Statement
For organization purposes, this project is divided into two phases, Phase I and Phase II.
- In Phase I, you will develop the foundation on which Phase II will be implemented.
- In Phase I, you will define a businessscenario, model the business data using an E-R diagram,
transpose the E-R diagram into relations, and normalize the relations.
Phase I: Conceptual and Logical Design (15 Points)
Particularly, you are asked to:
1. (5 points) Define a business scenario covering all business rules where a relational database is
needed. The business couldbe your friend’s startup, an established business (whether physical
or virtual, i.e., website), or a realistic made-up scenario. It is possible that a flawed database
solution exists, but you want to fix the current solution by proposing an efficient and secure
database. At the end of this step, you should:
a. (3 points) Explain the scenario for which you are designing a database.
b. (2 points) Define a minimum of four tasks that the end users should be able to
accomplish (in sync with the scenario described in (a) above).
i. Those are core business/user requirements.
ii. Examples include enrolling new students, registering new items, generating
reports of transactions in the last week/month, creating new tables (by
database admins only), defining user roles (by database admin only), and so on.
iii. Your database implementation should reflect these requirements, and you
should be able, in Phase II, to demonstrate to me how you accomplished those
core business/user requirements. This will be elaborated more in the upcoming
Phase II description.
2. (2 points) Based on the previous step, identify:
a. (1 point) List of Entities (with attributes including the PK, FK)
b. (1 point) List of Relationships between entities.
3. (3 points) Use a computer-aided tool, such as MS Visio, Lucidchart, or www.diagrams.net, to
draw an E-R diagram based on Step 2, above. The E-R diagram should include all components
in step 2 above.
4. (5 points) Transpose your E-R diagram into relations. You may show sample data for
demonstration purposes. Pick one relation (in 1st or 2nd NF) and Normalize it into 3rd NF
Page 2 of 5
ISTE 230 Project
Phase II: Physical Design (10 points)
In this phase, you will use SQL to implement a database for the business scenario you identified in Phase
I. You will demonstrate to me during your presentation how your database implementation achieves the
core business/user requirements from Phase I.
You are free to use whichever SQL queries you deem necessary. Populate your tables with sample
records. Showcase the various operations your database system supports.
The following are mandatory requirements for your implementation:
1. (5 points): Use MySQL to implement a database (create statements) for the business scenario
you identified in Phase I. You need to include your DDL commands in the report
2. (2 points): Choose any two of your business operations and write them in relational algebra
notations. Your relational algebra statements must include three or more of the following basic
operations:
a. Projection
b. Selection
c. Union
d. Intersection
e. Joins
3. (3 points): compose three SQL queries of your choice. You must demonstrate the use of the
following clauses (in any SQL statements): SELECT, WHERE, IS NULL, IN, EXISTS, LIKE, UNION,
any join, DELETE, and UPDATE.
Page 3 of 5
ISTE 230 Project
Deliverable
You will submit a PDF report, PPT presentation, and any supporting files, such as database files and
source drawing files.
Report
Your report will be marked out of 30 points (30% of overall course grade. Your report must contain the
following components/sections.
1. Include a cover page/slide with course title, assessment title, students’ names and IDs, date, and
group#.
2. Page 2: Manifesto
a. Clearly state the contributions of each team members.
b. If all team members contributed equally to the project, specify how.
c. If (b) above is not the case, then the manifesto must specify who did what. Students will
be graded based on their contribution to the team.
d. A complete work is still expected regardless who contributed to the work.
e. Not submitting a manifesto results in losing 10% of the project grade.
3. Page 3: Table of contents:
a. Clearly list each section/subsection and its related page.
4. Page 4: Write each step/requirement and its corresponding number along with your answer.
5. Your report must be clearly written and organized, otherwise, marks will be deducted.
Presentation (5 points)
Along with your report, you must also submit a presentation (10 Min max). All team members must be
present in- person during the presentation. Failure to do so will result in a zero for the missing team
member. Your team will present their work to me as per the specified deadline on the cover page of this
document.
Your presentation will be marked out of 5 points. The presentation will be evaluated based on the
following criteria:
1. (1 point) The presentation must be organized:
a. Cover slide that has course#, students’ names, group#, and date
b. Manifesto
c. Table of contents
d. Summary of business scenario
2. (2 points) Speak clearly, no stuttering, muttering, or reading from notes
a. Your presentation must reflect your full understanding of the database development
lifecycle.
b. You must be able to answer the instructor’s questions when asked.
c. Inability to answer instructor’s questions will negatively affect your presentation grade.
3. (2 points) Go over all the lifecycle phases and how you achieved each phase.
Page 4 of 5
ISTE 230 Project
Submission
This is a group-based project. You will work in a team of exactly 5 students. Your team will submit (1) a
PDF report, (2) PPT presentation, and (3) any supporting files, such as database files and source drawing
files, to
(1) myCourses → Assignments → Project → Report
(2) myCourses → Assignments → Project → Presentation
(3) myCourses → Assignments → Project → Supporting Files
Note that only a single submission per team is required. Enroll yourself in one of the groups that have
been created for you on myCourses; you will submit your work as a group (not individually). The
submission of all files must be done before your presentation.
The file name structures are as follows, where “Group#” is your group number, e.g., Group1:
ISTE230_Report_Group#.pdf
ISTE230_Presentation_Group#.ppt
ISTE230_SuppFiles_Group#
You are required to submit all supporting file, which include: source code, source drawings, documents,
dataset files (or their links), database files, and Excel sheets. A screenshot in your report without a
proper link to the source (e.g., Excel tables) will not be accepted.
Turnitin will be active, and you will be able to see your Similarity Score. High Similarity Scores (i.e., above
25%) will result in an automatic mark of zero. You have the option to resubmit your report if you wish to
modify it before the deadline. The portion of the Similarity Score that generates from copying parts of
this report or listing references, does not contribute toward the 25% limit.
Page 5 of 5
