लोकतंत्र की अवधारणा पर चर्चा कीजिए। लोकतंत्र के बुनियादी सि‌द्धांत क्या हैं?

A study was conducted on 185 patients aged more than 45 years, which were followed until the time of death or up to 10 years, whichever comes first. The patients have different covariates: age, gender (male/female), systolic blood pressure, smoking (yes/no), total serum cholesterol, and diabetes (yes/no). This study aims to determine which covariate influences the survival time. An analysis is conducted to investigate differences in all-cause mortality between men and women participating in the study. Suppose we obtain the following results after applying the Cox regression hazard model analyses:

(i) Obtain hazard ratio and interpret the results.

(ii) Find the 99% confidence interval for the hazard ratio.

(iii) Test whether the covariates are significant or not at 1% level of significance.

Describe censoring and differentiate between different types of censoring with the help of examples

To study the association between diabetic patients and their family history of diabetes, the following data were obtained on 70 subjects.

Which test is appropriate in this situation? Check whether the diabetes runs with generations in families or not at a 5% level of significance using a suitable test

Chi-square tests for association and proportions

Relative risk and odds ratio

Explain the logical design phase of database development of an organisation.

Find the total number of customers of the store.

List the product that has been ordered the most.

Find the total number of products in the store.

Find the number of orders given by cach customer.

List the name of the customers who have Ordered at least once.

Find the total amount of order of Order ID "000001".

Find the list of products whose quantity in stock is less than 5.

Find the list of products whose quantity in stock is less than 5.

List the Product name of all the products whose price is over INR 5000.

List the names of all the customers whose names start with the alphabet "A".

Design the Relational Schema for the E-R diagram you drew for Question 1. The relations must be at least in 3NF. Perform the following tasks using these relations:

a) Identify the domain of the attributes.

b) Identify the Primary key of every relation.

c) Identify the Foreign keys and referential integrity constraints in the relations.

Create the tables with keys and constraints and enter about five sets of meaningful data in cach relation

Design an ER diagram for a departmental Store. This store sells many products. The store keeps multiple quantities of these products. Each product is uniquely identified by a Product ID. In addition, the store maintains the Product Name, Price, Quantity in stock, Date of production, and Date of expiry of each product. The store sells these products to registered customers of the store. The store maintains the Customer ID, Name, Postal Address with City and Pin code, and Phone number of every customer. All the orders made by different customers are recorded in an order table. An order may consist of many products.

Identify and list the entities, attributes, relationships, cardinality, and key constraints for the description of the store given above. Make and state suitable assumptions.

Consider the following table for the connections between the input neurons and the hidden layer neurons.

The connections weights from Hidden layer neurons to the output neurons are 0.5, 0.3 and 0.6 for first, second and third neurons respectively corresponding threshold value for output layer is 0.5 and for hidden layer 1.8, 0.05 and – 0.2 for first, second and third neuron respectively,

(a) Draw the diagraph of the network.

(b) Write the results of activation and interpret.