Unit 2: Database Planning and Design

• Identify requirements and scope for the analysis phase.
• Identify guidelines for processing information in the analysis phase.
• Identify criteria for selecting a DBMS during the design phase.
• Identify considerations for DBMS interface.
• Identify considerations for testing a database prototype during the design phase.
• Identify considerations for building a database in the implementation phase.
• Sequence the steps for designing a conceptual database.
• Identify guidelines for establishing criteria for data representation.
• Identify features of entity groups.
• Identify the attributes of an entity.
• Identify features of ER building blocks.
• Match database anomalies with their definitions.
• Identify the cardinality of ERs.
• Match bottom-up transformation primitives with their functions.
• Identify features of the mixed strategy.
• Identify issues concerning data privacy and security.
• Match top-down transformation primitives with their functions.

Part 2 : Client/Server Development Tools

Designing and Implementing Distributed Applications with Microsoft Visual Basic 6.0 - Part 1

Unit 3: Client/Server Development Tools

• Identify the features of the client/server architectures, Microsoft Enterprise Development Strategy, phases of the Microsoft Solutions Framework (MSF) process model and the services of the MSF Application model, and the Visual Studio 6 Enterprise Edition development tools.
• Identify the attributes of an interface and conditions of using the interfaces and the functions of the different types of interfaces.
• Create, implement and access an interface.
• Identify the type of binding to be implemented and handle errors in an interface.
• Identify the advantages of COM components.
• Create a project to test a DLL and pass an error back to a client application.

Unit 4: Microsoft Enterprise Development Strategy

• Identify the features of client/server architecture.
• Identify the functionality that can be incorporated in a Web application to make it a three-tier client/server application.
• Identify the aspects of enterprise development.
• Identify the features of Microsoft Enterprise Development Strategy.
• Identify purposes of Microsoft Solutions Framework (MSF).
• Identify the milestone for each phase in the MSF development process.
• Identify the benefits of the MSF Application Model.
• Identify the purposes of the different services of the MSF Application Model.
• Identify the components and services of a logical design for a given scenario.
• Identify the application parameters based on which the impact of a logical design needs to be assessed.
• Identify the Visual Studio 6 Enterprise Edition tool for a given enterprise development scenario.
• Identify the Visual Studio 6 Enterprise Edition development tool for building an enterprise application according to a given set of technical needs.
• Install Visual Basic 6.0 Enterprise Edition.

Unit 5: Interfaces

• Identify the functionality provided by the various attributes of an interface.
• Identify the conditions to be met by the client and the server when using interfaces.
• Identify the IUnknown function that is called in a given situation.
• Identify the IDispatch function that is called in a given situation.
• Identify the contents of a dual interface.
• Create an interface.
• Implement an interface in a class.
• Implement polymorphism for clients.
• Implement multiple interfaces in a class.
• Access an interface from a client.
• Identify the type of binding that should be implemented in a given situation.
• Add the code used to trap errors that are generated when an interface is accessed from a class.

Unit 6: Component Object Model

• Identify how COM components provide certain advantages.
• Identify the specifications of COM.
• Select the type of COM component for a given set of requirements.
• Set project properties for a given situation.
• Set version compatibility for a project.
• Set the Instancing property for a COM component in a given situation.
• Add code to the built-in events in a class module.
• Create a method for a class.
• Create a project to test a DLL.
• Create an instance of a class.
• Pass an error back to a client application by using the Raise method.
• Call an existing component from a project.
• Identify the methods used for registering a COM DLL.
• Identify the registry keys that are generated when a COM DLL is compiled.
• Sequence the steps followed by VB to activate a COM object.

Part 3 : Client/Server Relational Databases

Database Technologies Part 1: Relational Database Fundamentals

Learn To

• Identify database concepts, database models, and logical modeling.
• Identify entities, relationships, and the physical design of relational databases.
• Identify relational data structure principles, normalization, and index structures.
• Identify database design, extended relational databases, implementation technologies, and database maintenance.

Unit 7: Relational Concepts

• Identify the implicit properties of a database.
• Match the database example with the industry in which it is used.
• Identify the characteristics of the database approach to file processing.
• Identify the characteristics of the hierarchical database model.
• Identify the characteristics of the network database model.
• Match the relational database model element with its definition.
• Match the database modeling method with its function.
• Identify the steps of the top-down approach to logical modeling.
• Sequence the steps of the bottom-up approach to logical modeling.

Unit 8: Entities and Data Relationships

• Identify the properties associated with entity relation.
• Label the entity relation documentation symbol with its meaning.
• Match the data relationship type with its example.
• Match the data relationship with the symbol used to document a relationship.

Unit 9: Relational Data Structure

• Identify the characteristics of a relation.
• Match each structure-related term with its definition.
• Match each value-related term with its definition.
• Match the key to its function.
• Identify the different index structures.
• Match each type of integrity constraint with its definition.
• Identify the reasons for performing normalization techniques.
• Match each normal form with its definition.
• Identify the features of a hash structure.
• Identify the features of a B-tree structure.
• Identify the instances where indexing occurs during query optimization.

Unit 10: System Implementation

• Select the phases of the database design process.
• Match the physical design type with its function.
• Identify the benefits of the Universal Server approach.
• Identify the benefits of using Middleware.
• Identify the benefits of the object-oriented approach to designing extended relational databases.
• Match the database software application with its vendor.
• Identify the features of an RDBMS.
• Match the database tools with their functions.
• Identify the types of database security mechanisms.
• Identify the advantages of using a distributed database.
• Identify the features of multi-tier architecture.
• Identify the advantages of remote data management.
• Match the database recovery technique with its function.

Unit 11: Project Work on real time environment.