Database Fundamentals: ERD, Relational Tables, and Queries

The assignment details the process of creating an ERD to support business needs, converting it to relational tables in at least 3NF, and drawing a dependency diagram. It also involves creating a database for CEP using MS Access with primary keys, foreign keys, and other attributes. Additionally, it includes creating forms to input/update data for candidates, inputting significant data into each table, and designing three queries (SELECT, JOIN, and numeric function).

Database
fundamentals

Table of Contents
INTRODUCTION ......................................................................................................................................3
MAIN BODY.............................................................................................................................................3
1). Create a complete ERD to support the business needs as described above.....................................3
3.Convert the ERD to a set Relational tables in at least 3NF and draw a dependency diagram. ...........4
3). Create a database for CEP using MS ACCESS - with primary keys, foreign keys and other attributes
mentioned for each entity..................................................................................................................5
4). Create a form to input/update data for Candidate........................................................................7
5). Input some significant data in each table showing your understanding of the scenario..................7
6. Create three queries - SELECT, JOIN and one NUMERIC Function query you can use any tables and
any fields...........................................................................................................................................9
CONCLUSION........................................................................................................................................12
REFERENCES..........................................................................................................................................13

·INTRODUCTION
Database management system is a process for collecting, managing, updating retrieving
the information effectively and efficiently (Williams and et.al., 2018). This report will discuss
about entity relationship diagram for showing the relationship between database tables. It also
implements database and solving queries.
·MAIN BODY
·1). Create a complete ERD to support the business needs as described above.
Entity relationship diagram is a graphical representation which help for designing an effective
and efficient tables. Entity relationship diagram is a process to establish relations between
entities and attributes.

l3.Convert the ERD to a set Relational tables in at least 3NF and draw a dependency diagram.
3NF – 3rd normal form is a technique or process which help for managing the data in efficient
manner. This normal form show reduces redundancy and data dependency.

This tables shows functional dependencies because CEP table splits into two different table
CEP table and Employee table.
Functional dependencies mean one table have one or more relations with another table and it is
useful for identifying the relationship between them (Cafaro and et.al., 2017).
l3). Create a database for CEP using MS ACCESS - with primary keys, foreign keys and other
attributes mentioned for each entity.
Database tables:
Candidates-
Employment provider-
Companies table-

Job table-
Employee table-

l 4). Create a form to input/update data for Candidate.
This screenshot shows the form of candidates that could be enter all the details and information of
particular candidates in proper manner.
l 5). Input some significant data in each table showing your understanding of the scenario.
This table is representing the shows the information of candidates and also add some information
in database table.

io
All the database table enter some details by using Ms accesss tool to create an effective table
which is useful for managing the collection of data in proper manner.

l6. Create three queries - SELECT, JOIN and one NUMERIC Function query you can use any
tables and any fields
Select functions: Candidates table:
Candidates database table
Queries :
Join function:
Companies with candidates

Queries:
Numeric function order by:
Employee table
Queries:
.

7. Create a report using any one of the above queries.
This query is design by using CEP database table with employee table and providing the
information and details such as CEP_id , CEP_name, CEP_email id, CEP_location, CEP_phone
number, emp_id, emp_name.
For creating a relationship using Join options to combine the both database table.
Select options uses for selecting details that could enter information in table (Shoval, 2018).

·CONCLUSION
This report is implementing database design and establishing different relationship
between database tables. Successfully completed the task for designing database system in
proper manner.

·REFERENCES
Books and Journals:
Cafaro and et.al., 2017, November. The NoXi database: multimodal recordings of mediated
novice-expert interactions. In Proceedings of the 19th ACM International Conference on
Multimodal Interaction(pp. 350-359). ACM.
Shoval, P., 2018. Evaluation of a Design Method for Graph Database. Enterprise, Business-
Process and Information Systems Modeling, p.291.
Williams and et.al., 2018. Toward the Rational Design of Sustainable Hair Dyes Using
Cheminformatics Approaches: Step 1. Database Development and Analysis. ACS
Sustainable Chemistry & Engineering, 6(2), pp.2344-2352.