Write a program in PL/SQL to Calculate Grade, GPA and CGPA after considering a result table where subject wise marks are inserted by computer operator. Insert your calculated result to another table using Trigger or Procedure or any other suitable way (suggested by you).
Design any sample table(s) with necessary field and values. After considering the below questions and demonstrate all the issues.
a. Triggers(Insert, Update, Delete)
Draw the ER diagram to design a system for a publishing company that produces scientific books on various subjects. The books are written by authors who specialize in one particular subject. The company employs editors who not necessarily being specialists in a particular area, each take sole responsibility for editing one or more publications.
A publication covers essentially one of the specialist subjects and is normally written by a single author. When writing a particular book, each author works with editor, but may submit another work for publication to be supervised by other editors. To improve their competitiveness, the company tries to employ a variety of authors, more than one author being a specialist in a particular subject.
Design a complete schema with relational diagram for the following situation: An organization has two types of employees, salaried and wage earning. Both the types of employees have some common properties, such as employee code, employee name, and employee address. However, the salaried employees have other additional properties: basic, allowance, and House Rent Allowance (HRA). The wage earning employees have distinct properties that are daily wage and overtime. You have to add additional table, if required, which is not mentioned above.
A university DB contains information about professors (identified by SIN) and courses (identified by course ID). Professors teach courses; each of the following situations concerns the Teaches relationship set. For each situation, draw a combined ER diagram and cardianility ratio that describes it, and list all candidate keys of the Teaches relationship set.
a. Professors can teach the same course in several semesters, and each offering must be recorded.
b. Professors can teach the same course in several semesters, but only the most recent such offering needs to be records. Assume the above Situation (b) applies in all subsequent situations. Then, draw an ER-diagram that describes each of the following situations:
i). Every professor teaches a course, and every course is taught by some professor.
ii). Every professor teaches exactly one course, and every course is taught by exactly one professor.
Consider a binary relationship with M: N cardinality ratio. A supplier supplies many engineering parts, and a part is supplied by many suppliers. Do the following action and assume the circumstances to design the table.
a. Design Table and consider non redundancy
b. Necessary Constraints for cardinality radio.
c. Check Constraint must be used for Suppliers’ City.
d. Find the supplier NUMBER and CITY who supply part P2
e. Find the supplier NUMBER(S) who belongs to London and supplied part P2
f. Find the supplier NUMBER who supplied maximum part
attribute (2) basic structure (1) begin (2) binary (1) cardinality (2) clause (1) client server (1) columns (1) constraint (1) create (1) data (1) data staging (1) data storage (1) data type (1) database (3) database models (1) dbms (3) dbms_output.put_line (3) ddbms (1) declare (2) dependent (1) directory service (1) distributed dbms (1) else (2) employee (1) employee information (1) end if (2) end loop (2) entity (2) exit (3) Fibonacci (1) Fibonacci series (1) field (1) first normal form (1) for (2) for loop (2) foreign key (1) from (3) if (3) informix (1) insert (1) itu (1) ldap (1) loop (1) metadata (1) mod (1) multi-valued dependencies (1) normalization (1) object (1) object base logical model (1) osi (1) perfect (2) perfect number (2) pl/sql (4) plsql (1) prime number (4) program (2) query (1) rdbms (2) record (2) record based logical model (1) relationship (1) reporting (1) rows (1) schema (2) select (3) sql (3) strange number (1) sybase (1) table (5) warehouse (1) where (1) while (1)
1. Write a program to count the prime number from previously stored values in a column of a table using pl/sql
1. Write pl/sql code to generate Fibonacci Series and save the series into a table. 2. Generate Fibonacci Series using a PL/SQL user defi...
1. Write a program to display all the perfect number from a column of a table. Use Cursor and User defined function.
Student Table Key word: Select, Create, Insert Schema: Entity/Field Name Data Type Student_id Number(10) ...
Write a program to check perfect number using pl/sql
What is SQL? SQL stands for Structured Query Language. SQL is used to communicate with a database. According to American National Stan...
(a) Consider the relational table given below and answer the following SQL queries. Think that the table has filled up by employee’s re...
What is Data Normalization ? Normalization is the process of efficiently organizing data in a database. There are two goals of ...
Write a pl/sql source code to check all data from a student_id column of a student table. After check show all student_id which are prime....
RDBMS RDBMS is the acronym for relational Database Management System. The Concept of relational is known since 1980’s but the idea o...