Please note that there are 2 parts to this project. This project mainly consists of writing. Part 1: The installation of SQL Server 2000 you've completed on your personal computer is not the same as an installation that would occur in a business or professional setting. SQL Server 2000 is based on a client/server architecture where there are multiple client machines that communicate with a single database server machine. An important part of a SQL Server DBA's job is to configure the network infrastructure to allow communications between the clients and the server. Describe in your own words the various types of clients that can be used to connect to SQL Server 2000 and the network requirements necessary for successful communications between the client and server. After describing the basic client architecture, be sure to include how the Named Pipes and TCP/IP Sockets Named Libraries differ. Finally, include your thoughts on the benefits and drawbacks of using ODBC to configure your client applications. ADDITIONAL OPTIONAL QUESTIONS: 1) Provide a screenshot of connecting to SQL 2000 from a client on another computer, describing the steps that you had to take to make this work. 2) Describe possible SQL installation problems and solutions. Requirement: Write all your answers in a 2 to 3 page Word document. Part 2: Use the internet to find information about database migratiom. Discuss why a company or organization would migrate to a relational database architecture from a network or hierarchical architecture. What are some of the factors that should be considered when transferring data from one database architecture to another? Notes: 1. Always list your citations and references. Requirement: 2 or 3 paragraphs in a word document.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).