WebReply. Unknown 29 January 2024 at 07:04. 2) A Create the above database in PostGreSQL and insert sufficient records. [5 marks] [6 marks] B Execute the following queries in … WebFYBCA DBMS SLIP1. Q-1) Consider the following entities and their relationships. Create a RDB in 3 NF with appropriate data types and Constraints. [15 Marks] Emp (eno ,ename ,designation ,salary, Date_Of_Joining) Dept (dno,dname ,loc) The relationship between Dept & Emp is one-to-many. Constraints: - Primary Key, ename should not be NULL, salary ...
FYBBA CA PracticalSlips Sem2 PDF Relational Database - Scribd
http://www.bcsbca.com/p/rdbms-practice-quations.html WebDec 10, 2024 · Solution:-. Create a Database in 3NF & write queries for following. •Find details of all customers whose loan is greater than 10 lakhs. SQL>select Customers.cust_name,Customers.address from Customers,Loan,Customer_Loan where Customers.cust_no=Customer_Loan.cust_no and Loan.loan_no= Customer_Loan. loan_no … steve carlisle wkrp in cincinnati main theme
Difference between RDBMS and DBMS - GeeksforGeeks
WebMay 17, 2024 · DBMS SOLVES PRACTICAL SLIPS. Slip no1:Consider the following entities and their relationships. Create a RDB in 3 NF with appropriate data types and Constraints. [15 Marks] Emp (eno ,ename ,designation ,salary, Date_Of_Joining) Dept (dno,dname ,loc) The relationship between Dept & Emp is one-to-many. Constraints: - Primary Key, ename … WebMar 25, 2024 · Slip no1: Consider the following entities and their relationships. Create a RDB in 3 NF with appropriate data types... RDBMS SOLVES PRACTICAL SLIPS. Slip no-1 Q3. Consider the following entities and their relationships. [40] Client (client_no, client_name, address, birthdate) Policy_info... R LANGUAGE SOLVES PRACTICAL SLIPS ... WebMay 17, 2024 · DBMS SOLVES PRACTICAL SLIPS. Slip no1:Consider the following entities and their relationships. Create a RDB in 3 NF with appropriate data types and Constraints. … steve casino art for sale