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
See Answer →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.
See Answer →Consider the following table for the connections between the input neurons and the hidden layer neurons.
| Input neuron | Hidden layer neurons | Connection weithts |
| 1 | 1 | 1 |
| 1 | 2 | 0.1 |
| 1 | 3 | -1 |
| 2 | 1 | 1 |
| 2 | 2 | -1 |
| 2 | 3 | -1 |
| 3 | 1 | 0.2 |
| 3 | 2 | 0.3 |
| 3 | 3 | 0.6 |
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.
See Answer →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 I1,I2,and I3,
What is the role of loss function in machine learning algorithms? Explain any two commonly used loss functions in machine learning algorithms.
See Answer →Semi-supervised.
See Answer →Reinforcement Learning,
See Answer →Unsupervised learning,
See Answer →Supervised Learning,
See Answer →Explain any two approaches for cross platform mobile app development.
See Answer →Which is the latest Mobile processor? Explain its architecture with the help of a diagram. Also, list any 5 features of it.
See Answer →What are the latest versions of Android and iOS? List atleast 5 features of each of them. Also, compare them.
See Answer →Consider the following two mobile apps: SWIGGY and ZOMATO. Now, compare them on the following parameters: (i) Ease of use (ii) Features (iii) Functionality. Make assumptions wherever necessary.
See Answer →Explain the concept of dynamic programming and the relation between dynamic and linear programming approach.
See Answer →Formulate and solve a discrete stochastic model for a single product with lead time zero. The storage and shortage costs are independent of time. The set-up cost is constant
See Answer →
Differentiate between foed-order quantity system and food interval system. Mention the advantages and disadvantages of both
See Answer →What are inventory models? Enumerate various types of inventory models and describe them briefly.
See Answer →What is a game in game theory? What are the properties of a game? Explain the best strategy on the basis of minimax criterion of optimality
See Answer →What are the four major types of allocation problems that can be solved using the linear programming technique? Briefly explain each with an example.
See Answer →What is the purpose of a mathematical model? How does a model achieve this purpose? In your answer consider the concept of a model an abstraction of reality.
See Answer →