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).
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
- Inner Query
- Delete Duplicate Rows
- Error 6 initializing SQL*Plus
- How to unlock user or scott account in oracle
- Query for a Relational Banking Enterprise
- Design a Relational Database for Bank Emoployees
- Construct sql for an accident management database
- Design a Database for Student's course wise marks ...
- find missing values
- Inventory System for a Shopping Mall
- Create a Result database using Oracle PL/SQL
- Before Insert Trigger
- Result Entry system under a Client-Server archite...
- Cursor Details in pl/sql in oracle
- Stored Procedure in pl/sql in oracle
- Introduction to Directory Services and Directory Server
- Nested Sub Query
- What Is Database Design And What Are The Factors To Consider?
- MBA MIS Study Link : Spring 2019
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)
Consider a binary relationship with M: N cardinality ratio. A supplier supplies many engineering parts , and a part is supplied by ma...
DBMS: Database management System is software, which is use for maintaining Database. Database System supports single-user and mult...
(a) Consider the relational table given below and answer the following SQL queries. Think that the table has filled up by employee’s re...
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...
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.
A university DB contains information about professors (identified by SIN) and courses (identified by course ID). Professors teac...
1. Write a program to count the prime number from previously stored values in a column of a table 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...
SQL অপারেটর ওরাকল অপারেটর এর মাধ্যমে একটি বা একাধিক আউটপুট তৈরী করা যায় । একই ভাবে অপারেটর একটি অথবা একাধিক অপারেন্ড / ভ্যালু(মান) / ...