CAP464 Database Administration
Date of Allocation: 10-Feb-10
Date of Submission: 22-Feb-10
Topics: Basics of SQL Server, Architecture, Installation
<<FIRST PAGE SHOULD BE>>
Lovely Professional University
Department of CA
Course Code: CAP553
Course Instructor: Sr. Lect. Ginnia Kakkar
Course Tutor (if applicable): NA
Date of Allotment: 10-Feb-10
Date of submission: 22-Feb-10
Student’s Roll Number: A17
Section No.: 3803
I declare that this assignment is my individual work. I have not copied from any other
student’s work or from any other source except where due acknowledgement is made explicitly in the
text, nor has any part been written for me by another person.
Student’s Sign: Rohan pahwa
Marks obtained: ____________ out of __________________
Q1. What is tier architecture?
Ans. Data tier is the database or the source of the data itself. Often in .NET it's an SQL Server or
Access database, however it's not limited to just those. It could also be Oracle, mySQL or even
XML. In this article we will focus on SQL Server, as it has been proven to be the fastest database
within a .NET Application.
The Single-Tier ODBC Drivers for Oracle are a single component installed on a data-
consuming machine - depending on the architecture in which the driver is deployed, either a
client such as a desktop, a workstation or an application-server machine. No components need
be installed on the database server.
Two-tier architecture, the server holds both the application and the data. The application
resides on the server rather than the client, probably because the server will have more
processing power and disk space than the PC.
Three-tier architecture, the data and applications are split onto separate servers, with the
server-side distributed between a database server and an application serve