logo

Database Fundamentals: ERD, Relational Tables, and Queries

   

Added on  2020-10-04

13 Pages801 Words175 Views
 | 
 | 
 | 
Databasefundamentals
Database Fundamentals: ERD, Relational Tables, and Queries_1

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

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 BODY1). 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.
Database Fundamentals: ERD, Relational Tables, and Queries_3

3.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.
Database Fundamentals: ERD, Relational Tables, and Queries_4

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents