Business reference

 

Outside Universe Consulting IT and Programming

(Branch of Alorya Ser.Teknoloji A.S. – Ankara) (previous our family`s company was Eski Istanbul Ltd. Co)

ORUÇ KENAN YILDIRIM

Manager

Adress: Cayyolu / Ankara

Cell: 0 535 930 66 18  

E-mail: oruc@outsideuniverse.com 

Web: http://www.outsideuniverse.com

Business Reference

Turkey Software developping reference:  Enka Insaat ,  Turbosan Ltd ,  Belgi Insaat

International Coder reference 

• UK  Government – Pensions and Amendments department - Helpdesk  database, and Document Control database.

• Smart Forms Corporation - USA:. Construction permits database design. 

• Diving SA - Australia  - Sport School Project

• Belgi Construction Company for Algeria  - Warehouse, Logistics and Finance database for Saida project  and Skikda Project 

Computer Literacy

I am a professional computer programmer. I participate to international programming bids. I have clients from USA, UK and Australia mainly.

Software Developping Visual Basic PHP / MYSQL ASP ASP.NET SQL  MS Access and all office applications

Web design and Database Javascript  HTML CSS Dreamweaver Flash

DBMS Keys

 Primary Key

source : guru99.com/dbms-keys.html

• 1 column or no column uniquely
• identify every row
• cannot accept null values
• only one primary key
• creates clustered index
• other naming:
• composite primary key
• it may or may not be part of the foreign key
• uniquely identify each record
• compound primary key
• 1 or many columns are primary key
• any part of compound key can be a foreign key

Unique key

source: geeksforgeeks.org/difference-between-primary-key-and-unique-key

• uniquely determines a row which isn`t primary key
• can accept one null value
• more than one unique key is possible
• Non clustered index (TR: kümelenmemiş)

Foreign Key

• Column that creates a relatıonshıp between 2 tables