Aanamcode | All program solution | Python |Machine learning | Data science

Programming languages are used in computer programming to implement algorithms. Most programming languages consist of instructions for computers. DBMS postgresql plpgsql sql trigger cursor table circuit programming C programing python program machin learning program are use Python. Python is one of the most commonly used programming languages Java. TypeScript # C (and C++) languages databas Trigger trigger cursor postgresql languages database create table fuction write a program

Showing posts from June, 2020Show all

Write a function to accept department name and display the average salary of employees in that department.

Write a cursor to accept the student's name from the user as an input and display names of all teachers teaching that student.

Create table Project and Employee relationship between many to many with descriptive attribute start_date.

Create table Item and Supplier are related with M-M relationship

Write a trigger before insert the record of the student in the Student table.

Write a cursor to accept the student's name from the user as an input and display names of all teachers teaching that student.

create tabel Department and Employee related with a one to many relationship

Create table Student and Teacher are related with many to many relationship

create table student and teacher are related with many to many relationship

Create Table Student and Subject are related with :M-M relationship

Write a cursor to display the names of items whose rate is more than 500.

Write a function to accept project name as input and returns the number of employees working on the project.

Write a cursor to display the names of suppliers in ‘Pune’ city.

create table Employee AND Project related with many to one relationship

Write a function which accepts employee name and prints the details of the project which the employee works on.

Write a trigger insertion is made to the employee table, trigger if age is less than 21 insertion not be allowed

Write a function which accepts account no as input and prints the details of that account.

Write a function using cursor which accepts customer name and prints all account details

create table Customer Account related with one to many relationship

Write a function accept the movie name as input and prints its release year and budget

Write a function using cursor, accept the actor name and print the names of all movies

Create table Movie Actor related with many to many relationship.