The ERD shows the entities and relationships in the database.

BANK_ERD.pdf: The Entity-Relationship Diagram (ERD) for the database.

The conceptual model shows the overall structure of the database.

Conceptual Model.pdf : The conceptual model of the database.

The DFD shows the flow of data through the database.

DFD.pdf : The Data Flow Diagram (DFD) for the database.

The data dictionary defines the data elements in the database.

Data_Dictionary.pdf : The data dictionary for the database.

The mapping shows how the ERD and the DFD are related

Mapping.pdfThe : mapping between the ERD and the DFD.

The relationship matrix shows the relationships between the entities in the database.

Relationship Matrix.pdf : The relationship matrix for the database.

The database schema is the actual definition of the database tables and columns.

database schema.txt : The database schema ( SQL sentax which creats the tables ).

The SQL queries in the QUERY_ANALYSIS.txt file can be used to analyze the data in the database.

QUERY_ANALYSIS.txt : The SQL queries used to analyze the database.

CREATE TABLE DEPARTMENT(DNAME varchar(45), 
DNUMBER INT PRIMARY KEY, 
MGRSSN INT, 
MGRSTARTDATE INT);

CREATE TABLE EMPLOYEE(FNAME varchar(45), 
MINIT varchar(45),SSN INT PRIMARY KEY, 
BDATE date,ADDRESS varchar(45), 
SEX varchar(45), 
SALARY float, 
SUPERSSN INT, 
DNO INT, 
foreign key(DNO) REFERENCES DEPARTMENT (DNUMBER)); 

CREATE TABLE PROJECTS ( 
    PNAME varchar(45), 
    PNUMBER INT PRIMARY KEY, 
    DNUM INT, 
    PLOCATION varchar(45), 
   foreign key(DNUM) REFERENCES DEPARTMENT(DNUMBER) 
);

CREATE TABLE DEPT_LOCATIONS(DNUMBER INT,DLOCATION INT PRIMARY KEY, 
foreign key(DNUMBER)REFERENCES DEPARTMENT(DNUMBER)); 

CREATE TABLE WORKS_ON(PNO INT, 
HOURS INT, 
ESSN INT, 
foreign key(PNO) REFERENCES PROJECTS(PNUMBER), 
foreign key(ESSN) REFERENCES EMPLOYEE(SSN) 
);

CREATE TABLE DEPENDENT ( 
    DEPARTMENT_NAME varchar(45), 
    ESSN INT, 
    SEX varchar(45), 
   BDATE date, 
    RELATRIONSHIP varchar(45), 
   foreign key(ESSN) REFERENCES EMPLOYEE(SSN) 
);