job platform

1. Project #: 20 Project Title: Job Board Platform Group Members: 1. Rysbek Nurgissa 2. 3.

Database Project
Presentation
Project #: 20
Project Title: Job Board
Platform
Group Members:
1. Rysbek Nurgissa
2.
3.
Subject: Introduction to Database
Course Instructor: Dr. Rahman Ali,
Assistant Professor in Artificial Intelligence & Data Science,
Woosong University Kazakhstan
Design & Development of a Database Project

2. Agenda

XP
• Introducing the Project
• Data Modeling
1. Conceptual Database Design – Conceptual Data Modeling
2. Logical Database Design – Logical Data Modeling
3. Physical Database Design – Physical Data Modeling (rarely)
Design & Development of a Database Project
2

3. Introduction

XP
• Title of the Project
Job Board Platform
• Project Scope/Application Area
This project is aimed to create a database for storing
job listings, employer profiles, job seeker details, and
applications submitted for different jobs across
various industries and locations.
Design & Development of a Database Project
3

4. Introduction

XP
• Objectives of the Project
To keep a record of employers and their profiles
To keep a record of job listings posted by each
employer
To keep a record of job seekers and their profiles
To keep a record of applications submitted by job
seekers for different job listings
To keep a record of the status of each application
Design & Development of a Database Project
4

5. Data Modeling

XP
1. Conceptual Data Modeling
Identify real-world objects (entities)
Identify Attributes
Define relationships between them
Capture business rules
2. Logical Data Modeling
Key Focus
No data types, no keys yet
(only ideas)
Avoid thinking in terms of
tables—focus on real-world
meaning
ERD
Transform ERD:
Entities Tables, Attributes Columns
Apply normalization
(1NF, 2NF, 3NF)
Defines Keys and Constraints
Primary keys & Foreign keys; Domain and Others
Relational Schema
3. Physical Data Modeling (rarely)
Define: Data types,, Indexes and providing storage details
Design & Development of a Database Project
5

6.

XP
Conceptual Data Modeling
(Conceptual Database Design)
Design & Development of a Database Project
6

7. Conceptual Data Modeling

XP
• Conceptual Database Design – Conceptual Data
Modeling
Identify real-world objects (entities)
Identify Attributes
Define relationships between them
Capture business rules
Design & Development of a Database Project
Key Focus
No data types, no keys yet
(only ideas)
Avoid thinking in terms of
tables—focus on real-world
meaning
ERD
7

8. Conceptual Data Modeling

XP
• Specify Entities
Employer
Job Listing
Job Seeker
Application
Design & Development of a Database Project
8

9. Conceptual Data Modeling

XP
• Specify and write down business rules
Each employer can post one or more job listings.
Each job listing belongs to only one employer.
Each job seeker can submit one or more applications.
Each application is submitted by only one job seeker.
Each application applies to only one job listing.
A job listing can receive applications from many job
seekers.
Each job seeker can have one profile.
Each employer can have one profile.
Design & Development of a Database Project
9

10. Entity Relationship Diagram(ERD)

XP
• Chen notation
Design & Development of a Database Project
10

11. Entity Relationship Diagram(ERD)

XP
• Crow’s notation
Design & Development of a Database Project
11

12. Entity Relationship Diagram(ERD)

XP
• UML Diagram
Design & Development of a Database Project
12

13.

XP
Logical Data Modeling
(Logical Database Design)
Design & Development of a Database Project
13

14.

XP
Physical Data Modeling
(Physical Database Design)
Design & Development of a Database Project
14

15. The End

XP
The End
Suggestion and
Recommendations
?
Design & Development of a Database Project
15

16. Bibliography

Design & Development of a Database Project
XP
16

17. Conceptual Data Modeling

XP
• Specify attributes of each entity
E.g. custId, custName etc.
Design & Development of a Database Project
17

18. Conceptual Data Modeling

XP
• Identify Relationship between Entities
E.g., customer, loan etc.
Design & Development of a Database Project
18