State Council For Technical Education And Vocational -Books Pdf

STATE COUNCIL FOR TECHNICAL EDUCATION AND VOCATIONAL
04 Feb 2020 | 35 views | 0 downloads | 17 Pages | 470.07 KB

Share Pdf : State Council For Technical Education And Vocational

Download and Preview : State Council For Technical Education And Vocational


Report CopyRight/DMCA Form For : State Council For Technical Education And Vocational



Transcription

Th 1 OPERATING SYSTEM,COMMON TO CSE IT, Theory 4 Periods per week Internal Assessment 20 Marks. Total Periods 60 Periods End Sem Exam 80 Marks,Examination 3hours Total Marks 100Marks. A Topic wise distribution of periods,Sl No Topics Periods. 1 INTRODUCTION 03,2 PROCESS MANAGEMENT 10,3 MEMORY MANAGEMENT 10. 4 DEVICE MANAGEMENT 10,5 DEAD LOCKS 10,6 FILE MANAGEMENT 10.
7 SYSTEM PROGRAMMING 07,B Rationale, The course provides the students with an understanding of Human computer interface existing. in computer system and the basic concepts of Operating System and its working The. students will gather knowledge about efficient utilization of the resources to obtain. optimization processing,C Objective, After completion of this course the student will be able to. Understand the concept and function of operating system. Understand notion of a process and all computation. To introduce the critical section problem whose solutions can be used to ensure the. consistency of the shared data, Understand the concept of deadlock its avoidance prevention and recovery. To provide a detailed description of various memory management techniques. To describe the benefits of a virtual memory system. To explain the function of file system, To describe the details of implementing local file systems and directory structures. Understand the brief idea of Systems Programming,D DETAIL CONTENTS.
1 INTRODUCTION, 1 1 Objectives and Explain functions of operating system. 1 2 Evolution of Operating system,1 3 Structure of operating system. 2 PROCESS MANAGEMENT, 2 1 Process concept process control interacting processes inter process messages. 2 2 Implementation issues of Processes,2 3 Process scheduling job scheduling. 2 4 Process synchronization semaphore,2 5 Principle of concurrency types of scheduling.
3 MEMORY MANAGEMENT,3 1 Memory allocation Techniques. Contiguous memory allocation,non contiguous memory allocation. 3 2 Swapping,3 3 Paging,Segmentation virtual memory using paging. 3 4 Demand paging page fault handling,4 DEVICE MANAGEMENT. 4 1 Techniques for Device Management,shared and, 4 2 Device allocation considerations I O traffic control I O Schedule I O Device.
4 3 SPOOLING,5 DEAD LOCKS,5 1 Concept of deadlock,5 2 System Model. 5 3 Dead Lock Detection,5 4 Resources allocation Graph. 5 5 Methods of Deadlock handling, 5 6 Recovery Prevention Explain Bankers Algorithm Safety Algorithm. 6 FILE MANAGEMENT, 6 1 File organization Directory file structure sharing of files. 6 2 File access methods file systems reliability,6 3 Allocation of disk space.
6 4 File protection secondary storage management,7 0 SYSTEM PROGRAMMING 7 1. Concept of system programming and show difference from Application Complier. 7 2 Compiler functions of compiler,7 3 Compare compiler and interpreter. 7 4 Seven phases of compiler brief description of each phase. Coverage of Syllabus upto Internal Exams I A,Chapter 1 2 3 4. Books recommended, Sl No Authors Title of the Book Name of the publisher. 1 Donovan Operating System TMH,Silverschz Operating.
2 Galvin System PHI,3 Er Rajiv Chopra System S CHAND. TH 2 DATA COMMUNICATION COMPUTER NETWORK,Common to CSE IT. Theory 4 Periods per week Internal Assessment 20 Marks. Total Periods 60 Periods End Sem Exam 80 Marks,Examination 3hours Total Marks 100Marks. A Topic wise distribution of periods,Sl No Topics Periods. 1 NETWORK PROTOCOL 08,2 DATA TRANSMISSION MEDIA 08.
3 DATA ENCODING 08,4 DATA COMMUNICATION DATA LINK CONTROL 08. 5 SWITCHING ROUTING 10,6 LAN TECHNOLOGY 10,7 TCP IP 08. B RATIONALE Now a days the growth of data communication technology has become very. fast in development of various application areas This subject will expose the learner to have. an idea about the architecture computer network and different protocols to be followed to. communicate Further they will have an idea about different mode of communication. C OBJECTIVE After completion of this course the student will be able to. Know the concepts of Data Communication networking protocols and networking. Know the various transmission Medias,Understand the concepts of switching. Understand various Error detection and correction methods. Know about data flow and error control,Know about data link control. Understand multiple access,Learn the concepts of wired LANs and Ethernet.
Compare various connecting devices, Know the concepts of network layer logical addressing IP Forwarding and routing. Understand brief concept on TCP IP,D CORSE CONTENTS. 1 Network Protocol,1 1 Data Communication,1 2 Networks. 1 3 Protocol Architecture Standards OSI TCP IP,2 Data Transmission Media. 2 1 Data transmission Concepts and Terminology,2 2 Analog and Digital Data transmission.
2 3 Transmission impairments Channel capacity, 2 4 Transmission media Guided Transmission Wireless Transmission. 3 Data Encoding,3 1 Data encoding,3 2 Digital data digital signals. 3 3 Digital data analog signals,3 4 Analog data digital signals. 3 5 Analog data analog signals,4 Data Communication Data link control. 4 1 Asynchronous and Synchronous Transmission,4 1 Error Detection.
4 3 Line configuration,4 4 Flow Control,4 5 Error Control. 4 6 Multiplexing,4 7 FDM synchronous TDM,4 8 Statistical TDM. 4 Switching Routing,5 1 Circuit Switching networks. 5 2 Packet Switching principles,4 4 Routing in Packet switching. 4 5 Congestion,4 6 Effects of congestion congestion control.
4 7 Traffic Management, 4 8 Congestion Control in Packet Switching Network. 6 LAN Technology,6 1 Topology and Transmission Media. 6 2 LAN protocol architecture,6 3 Medium Access control. 6 4 Bridges Hub Switch,6 5 Ethernet CSMA CD Fiber Channel. 6 6 Wireless LAN Technology,7 1 TCP IP Protocol Suite.
7 2 Basic Protocol functions,7 3 Principles of Internetworking. 7 3 Internet Protocol operations,7 4 Internet Protocol. Coverage of Syllabus upto Internal Exams I A,Chapter 1 2 3 4. Books recommended,Name of the,Sl No Name of Authors Title of the Book publisher. 01 W Stallings Data Communication PHI,Computer Networks.
02 M Bhatia Introduction to Comp Network Unv S Press. 03 Forouzen Data Communication TMH,Th 3 MICROPROCESSOR MICROCONTROLLER. Common ETC AE I CSE IT,Theory 5 Periods per Internal Assessment 20 Marks. Total Periods 75 Periods End Sem Exam 80 Marks,Examination 3hours Total Marks 100Marks. A Chapter wise Distribution of periods with Total periods. Sl No Topics Periods, 1 Microprocessor Architecture and Programming 8 15. 2 Instruction Set and Assembly Language 15,Programming 8 bit.
3 TIMING DIAGRAMS 07,4 Microprocessor Based System Development 11. 5 Microprocessor Architecture and Programming 12,16 bit 8086. 6 Microcontroller Architecture and Programming 8 15. B Rationale, The Microprocessor control has taken predominance over other types of control quite. some time past Starting from Electrical Power plant to consumer electronics this tiny chip. finds extensive uses As such Microprocessors have made pervading influence on our lives. This field is developing so rapid that it is difficult to keep track with the changes Under this. subjects Architecture and instruction sets of 8 bit and 16 bit processor have been discussed. Some applications have been included through the interfacing chips Microcontroller MC. may be called computer on the chip since it has basic features of a microprocessor with. internal ROM RAM Parallel and serial ports within a single chip Or we can say. microprocessor with memory and ports is called as a microcontroller Microcontroller is a. programmable digital processor with necessary peripherals Both microcontrollers and. microprocessors are complex sequential digital circuits meant to carry out job according to the. program instructions Sometimes analog input output interface makes a part of. microcontroller circuit of mixed mode both analog and digital nature. C Objective, After completion of this course the student will be able to. 1 The students will able to differential between 8085 microprocessor types of Bus. 2 Describe the Architecture pin diagram of 8085 microprocessor. 3 Comprehend different instructions of 8085 microprocessor addressing modes. 4 Write instructions under different addressing modes. 5 Discuss assembler basic assembler directives, 6 Describe types of assembly language programs and write programs.
7 Explain the timing diagrams of different instructions. 8 State the functions of the interfacing chips like 8255 etc. 9 Explain the delay subroutine calculate the delay by using one two or three registers. 10 Explain ADC DAC use of ADC DAC modules, 11 Write a program for traffic light control stepper motor control. 12 Know about 16 bit microprocessor,D Detailed Contents. Unit 1 Microprocessor Architecture and Programming 8 bit 8085. 1 1 Introduction to Microprocessor and Microcomputer distinguish between them. 1 2 Concept of Address bus data bus control bus System Bus. 1 3 General Bus structureBlockdiagram, 1 4 Basic Architecture of 8085 8 bit Microprocessor. 1 5 Signal Description Pin diagram of 8085 Microprocessor. 1 6 Register Organizations Distinguish between SPR GPR Timing Control. 1 7 Stack Stack pointer Stack top, 1 8 Interrupts 8085 Interrupts Masking of Interrupt SIM RIM. Unit 2 Instruction Set and Assembly Language Programming. 2 1 Addressing data Differentiate between one byte two byte three byte. instructions with examples, 2 2 Addressing modes in instructions with suitable examples.
2 3 Instruction Set of 8085 Data Transfer Arithmetic Logical Branching Stack. I O Machine Control,2 4 Simple Assembly Language Programming of 8085. 2 4 1 Simple Addition Subtraction, 2 4 2 Logic Operations AND OR Complement 1 s 2 s Masking of bits. 2 4 3 Counters Time delay Single Register Register Pair More than Two. 2 4 4 Looping Counting Indexing Call JMP etc,2 4 5 Stack Subroutinesprogrames. 2 4 6 Code conversion BCD Arithmetic 16 Bit data Operation Block. 2 4 7 Compare between two numbers, 2 4 8 Array Handling Largest number smallest number in the array. 2 5 Memory I O Addressing,Unit 3 TIMING DIAGRAMS, 1 1 Define opcode operand T State Fetch cycle Machine Cycle Instruction cycle.
discuss the concept of timing diagram, 1 2 Draw timing diagram for memory read memory write I O read I O write machine. 1 3 Draw a neat sketch for the timing diagram for 8085 instruction MOV MVI LDA. instruction, Unit 4 Microprocessor Based System Development Aids. 4 1 Concept of interfacing, 4 2 Define Mapping Data transfer mechanisms Memory mapping I O Mapping. 4 3 Concept of Memory Interfacing Interfacing EPROM RAM Memories. 4 4 Concept of Address decoding for I O devices,4 5 Programmable Peripheral Interface 8255. 4 6 ADC DAC with Interfacing,4 7 Interfacing Seven Segment Displays.
4 8 Generate square waves on all lines of 8255, 4 9 Design Interface a traffic light control system using 8255. 4 10 Design interface for stepper motor control using 8255. Unit 5 Microprocessor Architecture and Programming 16 bit 8086. 5 1 Register Organisation of 8086,5 2 Internal architecture of 8086. 5 3 Signal Description of 8086, 5 4 General Bus Operation Physical Memory Organisation. 5 5 Minimum Mode Timings,5 6 Maximum Mode Timings, 5 7 Interrupts and Interrupt Service Routines Interrupt Cycle Non Maskable Interrupt. Maskable Interrupt, 5 8 8086 Instruction Set Programming Addressing Modes Instruction Set Assembler.
Directives and Operators, 5 9 Simple Assembly language programming using 8086 instructions. Unit 6 Microcontroller Architecture and Programming 8 bit. 6 1 Distinguish between Microprocessor Microcontroller. 6 2 8 bit 16 bit microcontroller,6 3 CISC RISC processor. 6 4 Architectureof8051Microcontroller,6 5 Signal Descriptionof8051Microcontrollers. 6 6 Memory Organisation RAM structure SFR, 6 7 Registers timers interruptsof8051Microcontrollers. 6 8 Addressing Modes of 8051, 6 9 Simple 8051 Assembly Language Programming Arithmetic Logic Instructions.
JUMP LOOP CALL Instructions I O Port Programming,6 10 Interrupts Timer Counters. 6 11 Serial Communication, 6 12 Microcontroller Interrupts and Interfacing to 8255. Coverage of Syllabus upto Internal Exams I A,Chapter 1 2 3 4. Books Recommended, 1 Microprocessor architecture programming application with 8085 by R S Gaonkar. PenramInternational Publishing India Pvt Ltd, 2 The 8051 Microcontroller Embedded Systems by Mazidi Mazidi Pearson.
publication, 3 Advanced Microprocessor and Peripherals Architecture Programming Interfacing. by A K Roy K M Bhurchandi TMH Publication, 4 Microprocessor Microcontroller by N SenthliKumar M Sarvanan S Jeevananthan S. K Shah OXFORD, 5 Microprocessor Microcontroller by R S Kaler IKI Publishing. 6 Microprocessor its application by B Ram Dhanpat rai. 7 Microcontroller Theory and application by Ajaya V Deshmukh TMH. Th 4 DATABASE MANAGEMENT SYSTEM,COMMON TO CSE IT, Theory 4 Periods per week Internal Assessment 20 Marks. Total Periods 60 Periods End Sem Exam 80 Marks,Examination 3hours Total Marks 100Marks.
A Topic wise distribution of periods,Sl No Topics Periods. 1 BASIC CONCPETS OF DBMS 05,2 DATA MODELS 08,3 RELATIONAL DATABASE 06. 4 NORMALIZATION IN RELATIONAL SYSTEM 08,5 STRUCTURED QUERY LANGUAGE 09. 6 TRANSACTION PROCESSING CONCEPTS 08,7 CONCURRENCY CONTROL CONCEPTS 08. 8 SECURITY AND INTEGRITY 08, B RATIONALE Databases are wonderful learning tools because they embody so much of.
the learning process It is the vital component of modern information system which needs to. store and process large volume of data It gives an idea about accessing of data and shared. by different application programs The architecture of the database is simple to understand. C OBJECTIVE After completion of this course the student will be able to. Understand the database concepts their benefits and advantages. Understand the Database architecture, Understand the concepts of E R diagrams E R modeling. Understand relational algebra,Comprehend the different aspects of SQL. Understand the concepts of normalization,Understand the concepts of transaction processing. Understand the techniques of concurrency control, Comprehend the concepts techniques of backup recovery of database. Understand how to maintain security and integrity in database. D COURSE CONTENTS,1 0 BASIC CONCPETS OF DBMS,1 1 Purpose of database Systems.
1 2 Explain Data abstraction,1 3 Database users,1 4 Data definition language. 1 5 Data Dictionary,2 0 DATA MODELS,2 1 Data independence. 2 2 Entity relationship models, 2 3 Entity sets and Relationship sets 2 4 Explain Attributes. 2 5 Mapping constraints,2 6 E R Diagram,2 7 Relational model. 2 8 Hierarchical model,2 9 Network model,3 0 RELATIONAL DATABASE.
3 1 Relational algebra, 3 2 Different operators select project join simple Examples. 4 0 NORMALIZATION IN RELATIONAL SYSTEM,4 1 Functional Dependencies. 4 2 Lossless join,4 3 Importance of normalization, 4 4 Compare First second and third normal forms 4 5 Explain BCNF. 5 0 STRUCTURED QUERY LANGUAGE,5 1 Elementary idea of Query language. 5 2 Queries in SQL,5 3 Simple queries to create update insert in SQL.
6 0 TRANSACTION PROCESSING CONCEPTS,6 1 Idea about transaction processing. 6 2 Transaction system concept,6 3 Desirable properties of transaction. 6 4 Schedules and recoverability,7 0 CONCURRENCY CONTROL CONCEPTS. 7 1 Basic concepts,7 2 Locks Live Lock Dead Lock,7 3 Serializability only fundamentals. 8 0 SECURITY AND INTEGRITY,8 1 Authorization and views.
8 2 Security constraints,8 3 Integrity Constraints 8 4 Discuss Encryption. Coverage of Syllabus upto Internal Exams I A,Chapter 1 2 3 4. Books Recommended,Name of the,Sl No Name of Authors Title of the Book publisher. 01 Rog Cornel Database System Cengage Learning, 02 Prateek Bhatia Data Base System Kalyani Publications. 03 A Silberschatz H F Database System TMH Publication. Korth Concepts,04 C J Date An Introduction to Norosa Publication.
Database Systems,Pr 1 OPERATING SYSTEM LAB,Total Periods 60 Maximum Marks. Lab 4 Periods week Term Works 25 Marks, Examination 3hours End Semester Examination 25Marks. A LIST OF PRACTICALS, 1 Write a Shell script to print the command line arguments in reverse order. 2 Write a Shell script to check whether the given number is palindrome or not. 3 Write a Shell script to sort the given array elements in ascending order using bubble. 4 Write a Shell script to perform sequential search on a given array elements. 5 Write a Shell script to perform binary search on a given array elements. 6 Write a Shell script to accept any two file names and check their file permissions. 7 Write a Shell script to read a path name create each element in that path e g a b c. i e a is directory in the current working directory under a create b under b create. 8 Write a Shell script to illustrate the case statement. 9 Write a Shell script to accept the file name as arguments and create another shell. script which recreates these files with its original contents. 10 Write a Shell script to demonstrate Terminal locking. 11 Write a Shell script to accept the valid login name if the login name is valid then print. its home directory else an appropriate message, 12 Write a Shell script to read a file name and change the existing file permissions. 13 Write a Shell script to print current month calendar and to replace the current day. number by or respectively, 14 Write a Shell Script to display a menu consisting of options to display disk space the.
current users logged in total memory usage etc using functions. 15 Write a C program to fork a child process and execute the given Linux commands. 16 Write a C program to fork a child process print owner process ID and its parent. process ID, 17 Write a C program to prompt the user for the name of the environment variable check. its validity and print an appropriate message, 18 Write a C program to READ details of N students such as student name reg number. semester and age Find the eldest of them and display his details. Books Recommended,Sl No Name of the,Name of Authors Title of the Book publisher. 1 Sumitabha Das 4th Edition UNIX Concepts Tata McGraw Hill. and Applications 2006,3 Unix Sell Programming BPB Publication. Yashvant Kanetkar 1st edition,Pr 2 NETWORKING LAB,Total Periods 90 Maximum Marks.
Lab Periods 6 Periods week Term Works 50 Marks, Examination 3hours End Semester Examination 50Marks. A LIST OF PRACTICALS, 1 Recognize the physical topology and cabling coaxial OFC UTP STP of a network. 2 Recognition and use of various types of connectors RJ 45 RJ 11 BNC and SCST. 3 Making of cross cable and straight cable, 4 Install and configure a network interface card in a workstation. 5 Identify the IP address of a workstation and the class of the address and configure the. IP Address on a workstation,6 Managing user accounts in windows and LINUX. 7 Sharing of Hardware resources in the network,8 Use of Netstat and its options.
9 Connectivity troubleshooting using PING IPCONFIG. 10 Installation of Network Operating System NOS,11 Create a network of at least 6 computers. 12 Study of Layers of Network and Configuring Network Operating System. 13 Study of Routing and Switching configuring of Switch and Routers troubleshooting of. 14 Study of Scaling of Networks Design verities of LAN and forward of Traffic. 15 Study WAN concepts and Configure and forward Traffic in WAN. 16 Configure IPv4 and IPv6 and learn Quality security and other services. 17 Learn Network programming,18 Troubles shoot Networks. Pr 3 MICROPROCESSOR MICROCONTROLLER LAB,Common to ETC AE I CSE IT. Total Periods 60 Maximum Marks 50 Marks,Lab Periods 4 Periods week Term Works 25Marks. Examination 3hours End Semester Examination 25 Marks. A Rationale, The Microprocessor control has taken predominance over other types of.
control quite some time past Starting from Electrical Power plant to consumer. electronics this tiny chip finds extensive uses As such Microprocessors have made. pervading influence on our lives This field is developing so rapid that it is difficult to. keep track with the changes Under this subjects Architecture and instruction sets of 8. bit and 16 bit processor have been discussed Some applications have been included. through the interfacing chips,B Objective, After completion of this course the student will be able to. 1 The concept of Microprocessor 8085 8Bit,2 Concept of 16 Bit Processor 8086. 3 Programming Interfacing Concept, 4 Develop software for microcontroller systems using a high level programming. 5 Demonstrate familiarity with common microcontroller subsystems such as timer. 6 Demonstrate an ability to use both polling and interrupt driven approaches for. interfacing a microcontroller with peripheral devices. 7 Develop and analyze software to interface a microcontroller with common peripheral. devices such as switches visual displays digital to analog converters analog to. digital converters and flash memory to produce a system to accomplish a specified. 8 Design interfaces to external devices connected to the microcontroller using a. standard bus,C List of Practicals, NOTE Total 14 Experiments Have To Be Completed 4 from Gr A 3 from Gr B 4 from Gr. C 3 from Gr D,Gr A 8085 Compulsory, 1 Addition Subtraction Multiplication Division of two 8 bit numbers resulting 8 16 bit.
Optional Any three,2 1 s and 2 s Complements, 3 Binary to Gray Code Hexadecimal to decimal conversion. 4 Logic Operations AND OR Masking of bits, 5 Time delay Single Register Register Pair More than Two Register. 6 Compare between two numbers, 7 Smallest Largest number among n numbers in a given data array. 8 Block Transfer of data,Gr B 8086 Compulsory, 1 Addition subtraction Multiplication Division of 16 bit nos 2 s complement of a 16. Optional Any two, 2 Marking of specific bit of a number using look up table.
3 Largest Smallest number of a given data array, 4 To separate the Odd and Even numbers from a given data array. 5 Sorting an array of numbers in ascending descending order. 6 Finding a particular data element in a given data array. Gr C INTERFACING Compulsory any one, 1 Operation of 8255 using 8085 8051 microcontroller. 2 Generate square waves on all lines of 8255 with different frequencies concept of delay. OPTIONAL Any Three based on self study, 1 Study of stepper Motor and its operations Clockwise anticlockwise angular. movement rotate,in various speeds,2 Study of Elevator Simulator. 3 Generation of Square triangular and saw tooth wave using Digital to Analog Converter. 4 Study of 8253 and its operation Mode 0 Mode 2 Mode 3. 5 Study of Mode 0 Mode 1 BSR Mode operation of 8255. 6 Study of 8279 keyboard Display interface,7 Study of 8259 Programmable Interrupt controller.
8 Study of Traffic Light controller,9 Steeper Motor Controller. Gr D 8051 MICROCONTROLLER Compulsory by self study. 1 Initialize data to registers and memory using immediate register direct and indirect. addressing,OPTIONAL any two,2 Write a Program for,2 1 Bit Digital Output LED Interface. 2 2 8 Bit Digital Inputs Switch Interface,3 Write a Programs for Any one. 3 1 4 x 4 Matrix Keypad Interface,3 2 Buzzer Interface. 3 3 Relay Interface, 4 Write a Program for character based LCD Interface.
5 Write a Program for Analog to Digital Conversion On chip ADC DAC. 6 Interfacing With Temperature Sensor,7 Write a program Stepper Motor Interface. 8 Write a program to Generate Delay Subroutine, 9 805 Timer Counter programming Generate Square wave. Pr 4 DATABASE MANAGEMENT SYSTEM LAB,Total Periods 60 Maximum Marks. Lab Periods 4 Periods week Term Works 50 Marks, Examination 3hours End Semester Examination 50Marks. A ASSINGMENT FOR DBMS LAB, 1 Show the Structure of DEPT Select all data from DEPT table Create a query to display unique.
jobs from the EMP table, 2 Write a query to Name the column headings EMP Employee Job and Hire date respectively. Run the query, 3 Create a query to display the Name and salary of employees earning more than Rs 2850 Save. the query and run it, 4 Create a query to display the employee name and department no for employee no 7566. 5 Display the employee name job and start date of employees hire date between Feb 20 1981. and May 1 1981 Order the query in ascending order of start date. 6 Display the name and title of all employees who don t have a Manager. 7 Display the name salary and comm For all employee who earn comm Sort data in. descending order of salary and comm, 8 Display the name job salary for all employees whose job is Clerk or Analyst their salary is not. equal to Rs 1000 Rs 3000 Rs 5000, 9 Write a query to display the date Label the column DATE.
10 Create a unique listing of all jobs that are in department 30. 11 Write a query to display the name department number and department name for all. 12 Write a query to display the employee name department name and location of all employee. who earn a commission, 13 Write a query to display the name job department number and department name for all. employees who works in DALLAS, 14 Write a query to display the number of people with the same job Save the query run it. 15 Create a query to display the employee name and hire date for all employees in same. department, 16 Display the employee name and salary of all employees who report to KING. 17 Display the mane department name and salary of any employee whose salary and. commission matches both the salary and commission of any employee located in DALLAS. 18 Create a student database table using create command using Regd No as Primary Key insert. data of your class, 19 Delete the information of student having roll No 15 and City Bhubaneswar Rename the. Student database table to STUDENT INFORMATION, 20 Practice of all Data Retrieval DML DDL TCL and DCL commands used in Oracle by writing.

Related Books

Technical Report TR 87 September 1978

Technical Report TR 87 September 1978

methods for the repair and renovation of sewers and water mains. In this report types of fault commonly found in sewers are defined and the renovation methods are classified into nine types. A brief description of each method is given together with some guidance on cost where case history information was available. Suggested renovation methods for each fault type are presented in matrix form ...

Kentucky Medicaid Routine Code List - Passport

Kentucky Medicaid Routine Code List Passport

Kentucky Medicaid Routine Code List CPT_Code CPT II_Code HCPCS_Code 92002 2019F G0008 V2102 V2221 92004 2022F G0117 V2103 V2299 92012 2024F G0118 V2104 V2300 92014 2026F G0168 V2105 V2301 92310 2027F G0436 V2106 V2302 92340 3072F G0437 V2107 V2303 92341 3073F G0443 V2108 V2304 92342 3284F G0445 V2109 V2305 92352 3285F G0446 V2110 V2306 92353 4004F G0447 V2111 V2307 92370 4040F G0467 V2112 ...

Notes on HF Discone Antennas

Notes on HF Discone Antennas

Notes on HF Discone Antennas L. B. Cebik, W4RNL The discone antenna is a broadband basic antenna originally designed for VHF-UHF service. Indeed, it is a staple for upper-range scanning receivers. Developed during WWII by A. G. Kandoian, and brought to the attention of radio amateurs in the later 1940s, the following years saw conversions of the design to HF use. Amateurs have used it from 160 ...

White Paper Discone Antenna Design - hipoint.ca

White Paper Discone Antenna Design hipoint ca

A discone antenna derives its name from its unique appearance. The antenna is composed of a disc shaped radiator on top of a cone shaped ground plane. The two elements can be either solid or composed of separate elements. An antenna constructed from separate elements is lighter and more cost effective to construct. Inexpensive discone antennas are available with only three elements in the disk ...

PROCESS SIMULATION TECHNICS - ProSimTechs

PROCESS SIMULATION TECHNICS ProSimTechs

to optimize or troubleshoot your specific process. Data collected can be used to identify operating parameter changes to improve unit productivity, or gauge the accuracy of process modeling and simulation. A typical study employs a rigorous, accurate and customized model of the process taking into account the characteristics of the oil, the flowsheet and the equipment. The starting information ...

Hurricanes Katrina and Rita - Florida Office of Insurance ...

Hurricanes Katrina and Rita Florida Office of Insurance

Hurricanes Katrina and Rita Final Data Collection Summary Collected and provided by: National Association of Insurance Commissioners IDRS - Insurance Disaster Reporting System Note: Adjustments were made to Claims Information and Financial Projections due to erroneous data, duplications and/or hard-copy company submissions. Therefore, total claims reported may not match across reporting phases ...

Mathematics Standards - Louisville Catholic Schools

Mathematics Standards Louisville Catholic Schools

Rachel Burba Saint Rita Lori Graves Saint Dominic Heather Byers Saint Paul Grade 2 Amy Decker Saint Paul Jessica Young Saint Agnes Debbie Cunningham Saint Mary Caroline Robinson Saint Leonard Grade 3 Amy Malcolm Sacred Heart Model School Lisa Mattmiller Saint Gabriel Grade 4 Kathryn Crow Saint Mary Terri Lear Saint James-Elizabethtown Julie Daly Saint Agnes Grade 5 Diane Whoberry Saint Stephen ...

DAFTAR ISI S O P KESEKRETARIATAN I. Kasubag Umum

DAFTAR ISI S O P KESEKRETARIATAN I Kasubag Umum

13/Keuangan/2014 SOP Penyusunan Laporan Calk Korwil Dipa 005.04 Semesteran dan Tahunan 41. 14/Keuangan/2014 SOP Laporan Alokasi Belanja Daya dan Jasa 42. 15/Keuangan/2014 SOP Pelaporan SPT Tahunan Wajib Pajak III. Kasubbag Kepagawaian 43. 01/Kepegawaian/2014 SOP Kelengkapan File Pegawai 44. 02/Kepegawaian/2014 SOP Pembuatan Kartu Tik 45. 03/Kepegawaian/2014 SOP Pengarsipan Surat Dinas ...

BAB II LANDASAN TEORI A. Kantor Urusan Agama (KUA) 1 ...

BAB II LANDASAN TEORI A Kantor Urusan Agama KUA 1

mendukung semua lembaga keagamaan dan ditempatkan kedalam Kementerian Agama. Departemen Agama adalah departemen perjuangan. Kelahirannya tidak dapat dipisahkan dengan dinamika perjuangan bangsa. Pada . 1. Depag RI, Tugas-Tugas Pejabat . Pencatat. Nikah, Bimbingan Masyarakat Islam dan Penyelenggaraan Haji Departemen Agama RI, Jakarta, 2004, h.12. 22 saat bangsa. in. i berjuang mempertahankan ...

Radioactive Decay Mechanisms (cont.)

Radioactive Decay Mechanisms cont

Radioactive Decay Mechanisms (cont.) ... Decay Scheme of Co. 60 27 Co b-Figure by MIT OCW. Figure by MIT OCW. ?? 0.318 max (99.92%) 1.491 max (0.08%) ? 1.173 (99.98%) 1.332 (99.90%) Beta decay scheme . ?+ Decay Nuclides that are excessively proton rich can decay by positive electron (positron) emission. The nuclide attempts to gain stability by increasing the N/Z ratio by conversion of a