12M: 2) 2NF and 3NF with examples Second Normal Form (2NF): For a table to be in the Second Normal Form, It should be in the first normal form It should not have partial dependency 1 column primary key (Basically no 2 rows have the same primary keys) Example: Here the course code is unique and can be taken as primary key SUBJECT NAME COURSE CODE DBMS CS101 CD CS152 AI CS154 Storing student enrollment in various courses. Here, both the columns are not unique, but the tuple (student name, course code) is unique since a student cannot enroll in the same course more than once). But this is not the second normal form. STUDENT NAME COURSE CODE A CS152 B CS101 A CS154 C CS101 To convert to 2NF, we need to break it into 2 tables. In the first table, the second column is unique and we can attach each of these with the course codes in the second table STUDENT NAME ENROLLMENT NUMBER A 1 B 2 C 3 COURSE CODE ENROLLMENT NUMBER CS101 2 CS101 3 CS152 1 CS154 1 These 2 tables together provide u...
12M: Explain the types of intelligent agents. Agent: An agent is anything is anything that can be viewed as perceiving its environment through sensors and acting upon the environment through actuators Agent Program: Agent’s behavior is mathematically described by an agent function Agent’s behavior is practically described by an agent program It is the real implementation AI designs the agent program To design an agent program, we need to understand Percepts Actions Goals Environment Types: Simple reflex agents Model based reflex agents Goal based agents Utility based agents Simple reflex agents: Uses just condition action rules Works only if the environment is fully observable Model based reflex agents: For the world that is partially observable The agent has to keep track of an internal state that depends on the percept history Goal based agents: Current state of the environment is always not enough The goal is to achieve correctness Utility based agents: Goals alone are n...
12M: Business proposal - idea stage to minimum viable project and various processes The journey of idea to a minimum viable project (MVP) involves several key stages, each contributing to the successful realization of a business concept. Idea generation and research: Identify a market need: start by understanding the problem you aim to solve or the need you want to address. Research existing solutions and gaps in the market Market research: dive deeper into your target audience, competitors and industry trends. Gather insights to validate your idea Conceptualization: Brainstorm and ideate: collaborate with your team or stakeholders to generate creative ideas. Consider different angles and approaches Solution design: create a high level concept of your product. Define its purpose, features and potential benefits MVP development: What is MVP?: an MVP is the earliest version of your product that includes only essential features. It aims to deliver core value and validate it wi...
Comments
Post a Comment