logo

Database Fundamentals - Study Material with Solved Assignments, Essays, Dissertations

Design, build, query, and test a relational database.

22 Pages650 Words413 Views
   

Added on  2022-11-07

About This Document

This study material on Database Fundamentals introduces the concepts of schema, relational databases, data types, table, values, etc. and their associated procedures and functions. It includes an ERD with all entities and relationships, dependency diagram with 3NF normalization, forms, queries, and a report summarizing the information of the entire database.

Database Fundamentals - Study Material with Solved Assignments, Essays, Dissertations

Design, build, query, and test a relational database.

   Added on 2022-11-07

ShareRelated Documents
Running head: DATABASE FUNDAMENTALS
DATABASE FUNDAMENTALS
Name of Student
Name of University
Author Note
Database Fundamentals - Study Material with Solved Assignments, Essays, Dissertations_1
DATABASE FUNDAMENTALS1
Introduction:
Database Fundamentals can be described as the factors that introduces the concepts of schema,
relational databases, data types, table, values, etc. Database fundamentals are the main parts of the Database
management system (Elmasri and Navathe 2017). Various procedures, functions, normalization of tables are
associated with the fundamentals (Bhattacharya 2014). The scenario in the table aimed at creating the
database of the Course, with which Student, course, lecturer are associated. In this report different entities
with proper attributes has been shown.
1. ERD with all entities and relationships.
The ERD represents all the table and the relationship between them. An entity-relationship model
describes the data schema in the graphical form. According to the given scenario, there are 7 tables present
in the ERD of Degree, Student, Lecturer, Compulsory Modules, generated class, club for extra-curricular
activities so that students can participate.
Database Fundamentals - Study Material with Solved Assignments, Essays, Dissertations_2
DATABASE FUNDAMENTALS2
2. Dependency diagram with 3NF Normalization:
Database Fundamentals - Study Material with Solved Assignments, Essays, Dissertations_3
DATABASE FUNDAMENTALS3
Database Fundamentals - Study Material with Solved Assignments, Essays, Dissertations_4
DATABASE FUNDAMENTALS4
1NF:
Database Fundamentals - Study Material with Solved Assignments, Essays, Dissertations_5
DATABASE FUNDAMENTALS5
2NF:
Database Fundamentals - Study Material with Solved Assignments, Essays, Dissertations_6

End of preview

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

Related Documents
Database Fundamentals
|12
|1528
|94

Database Systems
|7
|609
|235

Entity Relationship Diagram for the Case Study
|11
|669
|409

MICRSOFT ACCESS DATABASE Microsoft Access Database.
|12
|283
|479

Database Systems - Computer Science
|7
|467
|17

Course Title and Code:.
|5
|645
|1