benga oguntokun portfolio
TRANSCRIPT
The following slides represent samples of my project work with SQL Server, both as a
Database Developer and an Administrator demonstrates my skills with the software
tools, and highlights my analytical and project based orientation to providing solutions to
business problems.
Overview.
Table of Contents
• Overview
• Bank Database Project
• Small Library Project (JungleBooks)
• Database Administration– Backup and Restore Operation
– Working With XML
BANK DATABASE PROJECT
• Introduction: The Bank Database Project was embarked on to design and develop a Database solution for a Commercial bank starting with the Entity-Relationship Diagram up to the delivery of the functional Database Solution to the Client.
• Audience:- Bank management - The end user: various clerical staff, cashiers e.t.c- Other stakeholders.
Project Goals:
• Requirement Gathering
• Creation of a Logical Database Design
• Creation of a Physical Database Design
• Implementing the Database
• Testing the Database
Entity-Relationship Diagram(Logical Design)
Physical (Implementing) DesignSample Code For Object Creation
Testing Sample Codes.Success
Testing Sample Codes.Failure
JungleBooks Project(Queries to Support Daily Operations)
• Introduction: JungleBooks is a small Library. The main objective of this project is to develop T-SQL Queries that would enable the end user to carry out the daily operations of the Library which the project requirements have itemized.
Relationship Diagram.(Junglebooks Project)
Sample Code.(Junglebooks Queries)
Restoring Accidentally Deleted Table(Database Administration)
Working With XML.
Thank You For Your Time!