Answer:-
Fixed Proportion = .065
Number of interns involved in accident last year = total number of interns*.065. n = .065*It where n denoted interns in an accident and It denotes the total number of interns.
P(n) = ItCn*.065^n*.935^(It-n)......from .binomial probability distribution the fixed parameter for probability of accident = .065.
P(5) = 20C5*.065^5*.935^15 = .0066
So the no of interns in an accident last year =total no of interns/ 0.5 =11/0.5 P(50) …show more content…
Also when we use classic tree methods it provides many number of sub nodes which is difficult to manage with the help of associative classification method. Pattern which is being used frequently is mainly used to classify the data, and when we use predefined pattern set there is no need of declaration every time, that’s why it gives higher accuracy.
Q. Show a multiple-key index for the data of Fig. 14.36 if the indexes are on:
a) Speed, then ram.
b) Ram then hard-disk.
c) Speed, then ram, then hard-disk.
Answer:-
Multiple key index consist of sequence of logical records of different sizes, and also each record will contain multiple data values, in which some may be unique and some may be copied or duplicate. The reason to do multiple indexing is that it cannot contain duplicate file, and that’s why two tables is created. One is hash table and other one is indexed table. Each index contains key value and address of the records, with byte count starting from 0. To find the indexes of the above situation we will follow the following command,
a) Speed, then ram.
Create Non Clustered Index IX index name on speed>ram
b) Ram then hard-disk.
Create Non Clustered Index IX index name on ram>hard-disk
c) Speed, then ram, then hard-disk.
Create Non Clustered Index IX index name on