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.

If the input vectors arand initial values of three weight vectors are then calculate the resulting weight found after training the competitive layer with Kohonen’s rule and a learning rate  of 0.5 on the input-series in order I_1,I_2,and I_3,

What is the role of loss function in machine learning algorithms? Explain any two commonly used loss functions in machine learning algorithms.

Semi-supervised.

Reinforcement Learning,

Unsupervised learning,

Supervised Learning,