Name : Patil Dinesh B. Unit/Block No.: Proposed date .:.:
Lesson no. : 47
Trade : COPA Impl. Date: Time :
Topic / Aim : Rules for designing tables, Data Integrity. Objective : (1)Rules for Designing Table
(2) Data Integrity constraints Aids : Chalk, Duster, Pointer. Preparation :
* Review :
* Intoduction : Designing Good Table With Relationship. Motivation : Data integrity in Relationship of Tables. Presentation :
Topics Information Points Tell Question (Ask)Spot hints / Rules for Designing
Table Field name Must be Between 0 to 255 Characters. Select proper Data type of Field.
Set the primary key. For NO-Duplication Set Default Value . For Blank Value Set Validation of Field
Set Format of Number Field Set Yes of Field for Data Must Be
entered
Set validation text for Validation Error
--> What is Table? -->what is Row and Column?
--> What are the rules of Table Designing ?
Data Integrity
Constraints What is Data Integrity ? Primary key
Check Constraints Default Constraints Foreign Key Unique Constraints
-->what is Data Integrity? -->what is Primary key? --> what is Check Constraints ? -->What is Default Constraints ?
-->What is Foreign Key? --> What is Unique Key?
APPLICATION :
Instructor Group Instructor Principal INDUSTRIAL TRAINING INSTITUTE
LESSON PLAN
Name : Patil Dinesh B. Unit/Block No.: Proposed date .:.:
Lesson no. : 48
Trade : COPA Impl. Date: Time :
Topic / Aim : Relation in table
Objective : (1)Relationship In Table. Aids : Chalk, Duster, Pointer. Preparation :
* Review :
* Intoduction : Designing Good Table With Relationship. Motivation : Data integrity in Relationship of Tables. Presentation :
Topics Information Points Tell Spot hints /
Question (Ask) Relationship In
Table What is Relationship ?Explain Types of Relation ship 1. One – to –one
2. One – to – many 3. Many –to –many 4. Many – to – one -->what is RDBMS ? --> what is Relationship? --> Explain Types of Relationship. APPLICATION :
SUMMARY : Rules of Designing Table with Data Integrity and Relationship ASSIGNMENT/ :
QUESTION
1 Difference Between Primary key and Foreign key 2 Explain Check, Default and Unique Constraints REFERENCE : Microsoft Access -2003 by Dummies
Instructor Group Instructor Principal
INDUSTRIAL TRAINING INSTITUTE
LESSON PLAN
Name : Patil Dinesh B. Unit/Block No.: Proposed date .:.
Lesson no. : 49
Trade : COPA Impl. Date: Time :
Topic / Aim : Introduction to various type of queries & their uses Objective : (1) How to create Queries and Form.
Aids : Chalk, Duster, Pointer.
Preparation : Importance of query and form in programming environment. * Review :
* Intoduction : Motivation : Presentation :
Topics Information Points Tell Question (Ask)Spot hints / Introduction Queries within a DBMS system can do more than
display answers to the questions you ask. They can actually perform various actions on the data in your database. Action queries are queries that can add, change, or delete multiple records at one time. The added benefit is that you can preview the query results in Access before you run it. Microsoft Access provides 4 different types of Action Queries: Make-Table, Append, Update, and Delete.
--> What is the full form of DBMS?
-->Click on the New button and then select Design View to start creating a query in Design view. Choose the tables or other queries you wish to query
-->Choose the fields from the table/query you want. Just like normal queries, you will often have to specify a criterion in your query to get the results you want.
--> Run the query to make sure your query contains the results are you are looking for. Now, you need to change the type of query this is. In the middle of the screen, click the Query
--> How can we create query?.
Create a Form
If you are creating the table for a separate database, you will have to specify the location of it.
Run the query.
-->Because you running an action query that makes changes to your overall database structure, Microsoft Access will ask if you want to cancel the operation.
Choose the fields from the table/query you want. --> Click Yes to close the dialog box, create the new table and return to Query Design View. -->Save your query, and you're done.
Microsoft Access will ask if you want to cancel the operation.
-->Ensuring the "Forms" tab is selected, click "New".
--> Select "Form Wizard" and click "OK". (For now, we'll use the "Form Wizard" to create a form. Once you become comfortable with creating forms, you can choose another option if you prefer).
--> Select the fields that you need on your form and click "Next". In this case, we only need the user to enter first name and last name, so we choose those two fields:
-->Choose which layout you'd like your form to use. Leave this at the default ("Columnar") and click "Next":
-->Choose which style you'd like your form to use. Leave this at the default ("Clouds") and click "Next":
-->Choose a name for your form and click "Finish":
--> What is Form?
--> Explain Creation of a form?
APPLICATION :
SUMMARY : Queries are used to do task and forms are collectors of multiple objects. ASSIGNMENT/ :
QUESTION (1) What is the full form of DBMS?(2) What is Query and Form? (3) Explain Query creation.
Name : Patil Dinesh B. Unit/Block No.: Proposed
date .:. Lesson no. : 50
Trade : COPA Impl. Date: Time :
Topic / Aim : Introduction , necessary and advantages of computer network Objective : 1) Networking.
2) Client and Server. 3) Peer to Peer Network. Aids : Chalk, Duster, Pointer.
Preparation : Importance of Networking in Computing Environment.. * Review :
* Intoduction : Networking. Motivation :
Presentation :
Topics Information Points Tell Spot hints /
Question (Ask) Network A computer network or data network is a
telecommunications network that allows computers to exchange data. In computer networks, networked computing devices pass data to each other along data connections. Data is transferred in the form of packets
--> What is the Network?
APPLICATION : Networking is used in many areas like railway,telecome sector …etc
SUMMARY : A computer network or data network is a telecommunications network that allows computers to exchange data.
ASSIGNMENT/ : QUESTION
(1) What is the Network? (2) What is a client server network? (3) What is a peer to peer network?
REFERENCE : .
Instructor Group Instructor Principal
INDUSTRIAL TRAINING INSTITUTE LESSON PLAN
Name : Patil Dinesh B. Unit/Block No.: Proposed
date .:. Lesson no. : 51
Trade : COPA Impl. Date: Time :
Topic / Aim : Client server and peer to peer concept. Objective : 1) Client and Server.
2) Peer to Peer Network. Aids : Chalk, Duster, Pointer.
Preparation : Importance of Networking in Computing Environment.. * Review :
* Intoduction : Networking. Motivation :
Presentation :
Topics Information Points Tell Question (Ask)Spot hints /
Client Server Network
-->Client/server is a program relationship in which one program (the client) requests a service or resource from another program (the server). -->Although the client/server model can be used by programs within a single computer, it is a more important concept for networking. In this case, the client establishes a connection to the server over a local area network (LAN) or wide-area network (WAN), such as the Internet. Once the server has fulfilled the client's request, the connection is terminated. Your Web browser is a client program that has requested a service from a server; in fact, the service and resource the server provided is the delivery of this Web page.
--> What is Client-Server network?
Peer to Peer Network
common and the client/server model has become one of the central ideas of network computing. Most business applications use the client/server model as does the Internet's main program, TCP/IP.
-->Both client programs and server programs are often part of a larger program or application. Because multiple client programs share the services of the same server program, a special server called a daemon may be activated just to await client requests.
-->In marketing, the client/server was once used to distinguish distributed computing by personal computers (PCs) from the monolithic, centralized computing model used by mainframes. This distinction has largely disappeared, however, as mainframes and their applications have also turned to the client/server model and become part of network computing.
-->A peer-to-peer (P2P) network is created when two or more PCs are connected and share resources without going through a separate server computer.
--> A P2P network can be an ad hoc connection a couple of computers connected via a Universal Serial Bus to transfer files.
--> A P2P network also can be a permanent infrastructure that links a half-dozen computers in a small office over copper wires. Or a P2P network can be a network on a much grander scale in which special protocols and applications set up direct relationships among users over the Internet. -->The initial use of P2P networks in business followed the deployment in the early 1980s of free-standing PCs.
--> What is a peer to peer network?
APPLICATION : Networking is used in many areas like railway,telecome sector …etc
SUMMARY : A computer network or data network is a telecommunications network that allows computers to exchange data.
ASSIGNMENT/ :
QUESTION (1) What is the Network? (2) What is a client server network? (3) What is a peer to peer network?
REFERENCE : .
NEXT LESSON : Concepts of Proxy Server, Firewall Server
INDUSTRIAL TRAINING INSTITUTE LESSON PLAN
Name : Patil Dinesh B. Unit/Block No.: Proposed date .:.:
Lesson no. : 52
Trade : COPA Impl. Date: Time :
Topic / Aim : Concepts of Proxy Server, Firewall Server Objective : (1) Server Details
(2) Difference between Proxy , Firewall and other Servers Aids : Chalk, Duster, Pointer.
Preparation : * Review :
* Intoduction : Server and Network topology
Motivation : Using Servers like FTP for file sharing. Presentation :
Topics Information Points Tell Question (Ask)Spot hints / About Proxy Server,
Firewall Server computer program which managesIt is a computer or
access to a centralized resource or service in a network.
A firewall and a
proxy server are both components of network security.
Proxy Server acts as a firewall between internal and external network.
Firewalls can block ports and programs that try to gain unauthorized access to your computer, while proxy servers basically hide your internal network from the Internet.
--> What is Server?
--> What is the Difference between Proxy and
Firewall Proxy Server?
(3) Difference between Proxy Server and Firewall Proxy Server. (4) Give the difference between network topologies.
REFERENCE :
NEXT LESSON : Network topologies
Instructor Group Instructor Principal
INDUSTRIAL TRAINING INSTITUTE LESSON PLAN
Name : Patil Dinesh B. Unit/Block No.: Proposed date .:.:
Lesson no. : 53
Trade : COPA Impl. Date: Time :
Topic / Aim : Network topologies Objective : (1) Server Details
(2) Different Types of Servers & Network Topologies (3) Difference between Proxy , Firewall and other Servers Aids : Chalk, Duster, Pointer.
Preparation : * Review :
* Intoduction : Server and Network topology
Motivation : Using Servers like FTP for file sharing. Presentation :
Topics Information Points Tell Question (Ask)Spot hints / Network Topologies Types of Networks are LAN, MAN,
WAN.
Network topology is the arrangement of
the various elements (links, nodes, etc.) of a computer network.
Types of Network Topologies are Bus Topology, Ring Topology, Star Topology etc.
--> What is full form of LAN, MAN & WAN? --> Why Network Topologies are used?
Terminology : LAN: LAN stands for Local Area Network which is used for networking in particular office or building.
MAN: MAN stands for Metropolitan Area Network which is a large computer network that spans a metropolitan area or campus.
WAN: WAN stands for Wide Area Network which is a network that covers a broad area using different communication mediums.
Topology: Refers to layout of a network.
Bus Topology: Simplest Network
topology whose components are connected by bus bar.
Ring Topology: It is a topology in which
each node connects to exactly two other nodes.
Star Topology: In this topology, every node is connected to a central node called a hub or switch.
--> What are network terminologies?
APPLICATION :
SUMMARY : Network Topologies makes network work easily. Server makes network and information fast and secure.
ASSIGNMENT/ : QUESTION
(1) What is the full form of LAN, MAN, WAN? (2) What is Topology?
(3) Difference between Proxy Server and Firewall Proxy Server. (4) Give the difference between network topologies.
REFERENCE :
NEXT LESSON : Introduction to LAN,WAN,MAN
Name : Patil Dinesh B. Unit/Block No.: Proposed date .:.:
Lesson no. : 54
Trade : COPA Impl. Date: Time :
Topic / Aim : Introduction to LAN,WAN,MAN Objective : LAN,WAN,MAN
Aids : Chalk, Duster, Pointer. Preparation :
* Review :
* Intoduction : Server and Network topology
Motivation : Using Servers like FTP for file sharing. Presentation :
Topics Information Points Tell Spot hints /
Question (Ask) LAN,WAN,MAN Types of Networks are LAN, MAN,
WAN.
Network topology is the arrangement of
the various elements (links, nodes, etc.) of a computer network.
Types of Network Topologies are Bus Topology, Ring Topology, Star Topology etc.
--> What is full form of LAN, MAN & WAN? --> Why Network Topologies are used?
LAN: LAN stands for Local Area Network which is used for networking in particular office or building.
MAN: MAN stands for Metropolitan Area Network which is a large computer network that spans a metropolitan area or campus.
WAN: WAN stands for Wide Area Network which is a network that covers a broad area using different communication mediums.
Topology: Refers to layout of a network.
Bus Topology: Simplest Network
topology whose components are connected by bus bar.
Ring Topology: It is a topology in which
each node connects to exactly two other nodes.
Star Topology: In this topology, every node is connected to a central node called a hub or switch.
--> What are network terminologies?
APPLICATION :
SUMMARY : Network Topologies makes network work easily. Server makes network and information fast and secure.
ASSIGNMENT/ : QUESTION
(1) What is the full form of LAN, MAN, WAN? REFERENCE :
NEXT LESSON : Network Components
Name : Patil Dinesh B. Unit/Block No.: Proposed date .:.:
Lesson no. : 55
Trade : COPA Impl. Date: Time :
Topic / Aim : Network Components Objective : (1) Network Components
(2) Use of Network Components Aids : Chalk, Duster, Pointer.
Preparation : * Review :
* Intoduction : Network Components
Motivation : Network Component used in lab for networking. Presentation :
Topics Information Points Tell Question (Ask)Spot hints / Network
Components Basically the Hardware we use forNetworking is called Network Components.
Generally network components includes devices like gateways, routers, network bridges, switches, hubs, and repeaters. Apart from traditional network devices it
also includes hybrid network components for hybrid network.
What is Network Components?
Why it is essential to use network components in network?
Modem
Modem stands for MOdulator DEModulator.
Modem is known as Data Phone.
It is used to send and receive data to the computer using phone line.
It is Asynchronous device.
Types of modems are internal modem, external modem and removable modem.
--> What is full form of Modem?
--> Why it is used? Types of Modem.
Switch
Switch is used to connect more than one computer in a LAN.
According to the speed of network we use switches.
For better work more than one switch can be connected to network which is called daisy chaining.
It works on datalink layer.
Where we use switch? Types of Switch.
Routers
Router is a physical device which is used in network layer.
It is called as a Gateway device.
In network Wireless and Wired both routers are used.
It works like switch and bridge in which it filters packets and used to connect two networks.
Router divides network logically.
Types of router.
Protocol used for routing of packets.
Network Bridge
Bridge is either a software or hardware which is used to connect two or more networks.
Bridge works on the data link layer. It decides that in network either stop or
forward network traffic.
It is almost same like switch but it allows only one network boundary where as switch allows 4 or more than it.
Difference between switch and bridge.
Gateway
This device is placed at a network node and interfaces with another network that uses different protocols.
the need of the network, network components are used. ASSIGNMENT/ :
QUESTION (1) What is the full form of Modem?(2) What is router? (3) Difference between switch and bridge. REFERENCE :
NEXT LESSON : Network Cables,
Instructor Group Instructor Principal
INDUSTRIAL TRAINING INSTITUTE LESSON PLAN
Name : Patil Dinesh B. Unit/Block No.: Proposed date .:.:
Lesson no. : 56
Trade : COPA Impl. Date: Time :
Topic / Aim : Network Cables, Objective : (1) Types of cables. Aids : Chalk, Duster, Pointer. Preparation :
* Review :
* Intoduction : Networking Cables and Mediums. Motivation :
Presentation :
Network Cables Networking cables are used to connect one network device to other network devices or to connect two or more computers to share printer, scanner etc. Different types of network cables
like Coaxial cable, Optical fiber cable, Twisted Pair cables are used
depending on the
network's topology, protocol and size. Twisted pair cabling is a form of wiring
in which pairs of wires are twisted together for the purposes of canceling out electromagnetic (EMI) from other wire pairs and from external sources. This type of cable is used for home and corporate Ethernet networks.
An optical fiber cable consists of a center glass core surrounded by several layers of protective material. The outer insulating jacket is made of Teflon or PVC to prevent interference. It is expensive but has higher bandwidth and can transmit data over longer distances. Coaxial lines confine the electromagnetic
wave to area inside the cable, between the center conductor and the shield. The transmission of energy in the line occurs totally through the dielectric inside the cable between the conductors.
Types of Network Cables.
Terminology : Protocol: A protocol is a set of rules and standards that basically define a
language that devices can use to communicate.
APPLICATION : SUMMARY : ASSIGNMENT/ : QUESTION
(1) Types of Network Cables. (2) Use of different cables. REFERENCE :
INDUSTRIAL TRAINING INSTITUTE LESSON PLAN
Name : Patil Dinesh B. Unit/Block No.: Proposed date .:.:
Lesson no. : 57
Trade : COPA Impl. Date: Time :
Topic / Aim : Wireless Networking & Blue Tooth Technology Objective : (1) Types of cables.
(2) Wireless technology (3) Bluetooth technology. Aids : Chalk, Duster, Pointer. Preparation :
* Review :
* Intoduction : Networking Cables and Mediums. Motivation :
Presentation :
Wireless Networking
Using Infrared Signals or Radio Frequency Signals connect computer or any other device in the home or any other place is called Wireless Networking.
Two types of Wireless LANs are there. (1) Infrastructure Network (2) Ad-hoc Network. What is Wireless Technology? What is Ad-hoc Network? Blue Tooth
Technology Blue Tooth is a Wireless Protocol.
It is used to connect devices without using LAN but those devices must be in the range of Bluetooth.
Bluetooth can communicate up to 1MBPS Speed.
It can transmit the signals comes in the range of 0 to 30 feet.
Bluetooth network is comparatively slower than wifi.
What is Bluetooth technology?
Where we use Bluetooth technology now days?
Terminology : Protocol: A protocol is a set of rules and standards that basically define a lang that devices can use to communicate.
APPLICATION : SUMMARY : ASSIGNMENT/ : QUESTION
(1) What is Wireless Technology?
(2) Difference between Bluetooth and Wifi. REFERENCE :
NEXT LESSON : OSI Layer Model
INDUSTRIAL TRAINING INSTITUTE LESSON PLAN
Name : Patil Dinesh B. Unit/Block No.: Proposed date .:.:
Lesson no. : 58
Trade : COPA Impl. Date: Time :
Topic / Aim : OSI-7 Layer Model & Network Protocol Objective : (1) Standard Model for Data Communications
(2) Strategy for connecting host computers and other communicating equipment.