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
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.
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.
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents
Database Design and Implementationlg...
|9
|867
|181
Database Fundamentals - Study Material with Solved Assignments, Essays, Dissertationslg...
|22
|650
|413
DATABASE DESIGN AND IMPLEMENTATION.lg...
|7
|241
|279
Database Management System | Report | Assignmentlg...