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)
Write a program to check prime number using pl/sql
Write pl/sql code to generate Fibonacci Series
Write a program to check perfect number using pl/sql
SQL অপারেটর ওরাকল অপারেটর এর মাধ্যমে একটি বা একাধিক আউটপুট তৈরী করা যায় । একই ভাবে অপারেটর একটি অথবা একাধিক অপারেন্ড / ভ্যালু(মান) / ...
Draw the ER diagram to design a system for a publishing company that produces scientific books on various subjects. The books are writ...
Design any sample table(s) with necessary field and values. After considering the below questions and demonstrate all the issues. a. ...
(a) Consider the relational table given below and answer the following SQL queries. Think that the table has filled up by employee’s re...
Write a program in PL/SQL to Calculate Grade, GPA and CGPA after considering a result table where subject wise marks are inserted by c...
Aggregate Functions Aggregate functions return a single result row based on groups of rows, rather than on single rows. Aggregate funct...
A binary relationship with 1:1 cardinality ratio, an employee can have one car and a car is used by one employee only. Do the following a...