logo

Database Concepts and Operations

   

Added on  2020-04-13

8 Pages548 Words58 Views
 | 
 | 
 | 
Running head: BASIC DATABASE CONCEPTSBasic Database ConceptsName of the Student:Name of the University:Author note:
Database Concepts and Operations_1

1BASIC DATABASE CONCEPTSTable of ContentsJoining Tables and Relationships....................................................................................................3INNER JOIN...............................................................................................................................3LEFT JOIN..................................................................................................................................3RIGHT JOIN...............................................................................................................................4FULL OUTER JOIN...................................................................................................................4FOREIGN KEY...........................................................................................................................4Data Manipulation...........................................................................................................................4INSERT.......................................................................................................................................4DELETE......................................................................................................................................5UPDATE......................................................................................................................................5RETRIEVE DATA......................................................................................................................5Change Database Structure..............................................................................................................6Changing Constraints...................................................................................................................6Adding/Altering Field Properties................................................................................................6
Database Concepts and Operations_2

2BASIC DATABASE CONCEPTSThe tables that are being referred to are as follows:1. Table StudentCREATE TABLE Student (id int PRIMARY KEY,name varchar(255));2. Table FeeCREATE TABLE Fee (id int NOT NULL PRIMARY KEY,slipNo int NOT NULL,FOREIGN KEY (id) REFERENCES Student(id));3. Table ProcessedFeeCREATE TABLE ProcessedFee (proID int NOT NULL,slipNo int NOT NULL,employeeID int NOT NULL,
Database Concepts and Operations_3

End of preview

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

Related Documents
Database Management System: Entity Relationship Diagram, SQL Queries, Legal Issues and Security Techniques
|16
|1912
|240

ITECH 1006 : The Database Management System Report
|21
|3550
|123

TRA Race Entry System Author: Name + Number.
|7
|471
|85

Database Design and SQL
|29
|3169
|92

Primary and Foreign Key | Exercise Solutions
|8
|1070
|31

Recommendation System
|14
|1245
|258