Ask a question from expert

Ask now

Database Fundamentals Assignment

13 Pages801 Words175 Views
   

Added on  2020-10-04

Database Fundamentals Assignment

   Added on 2020-10-04

BookmarkShareRelated Documents
Databasefundamentals
Database Fundamentals Assignment_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 Assignment_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 Assignment_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 Assignment_4

End of preview

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

Related Documents
Database Design and Implementation
|9
|867
|181

Database Fundamentals - Study Material with Solved Assignments, Essays, Dissertations
|22
|650
|413

DATABASE DESIGN AND IMPLEMENTATION.
|7
|241
|279

Database Management System | Report | Assignment
|7
|719
|50

Database Systems
|7
|609
|235

Database Fundamentals
|16
|1609
|70