ENROL (ENo, C_Id, Class) – ENo represents student numberTEACH (Prof, C_Id, Class) – C_Id represents course numberADVISE (Prof, ENo) – Prof is project guide of ENo (Student’s enrol_no)PRE_REQ (C_Id, Pre_C_Id) – Pre_C_Id is prerequisite courseGRADES (ENo, C_Id, Grade, Year)STUDENT (ENo, SName) – SName is student Read More …
Blog
“For creating a Employee Management Information System of an Organisation a database management system(DBMS) is better or a file management system.” Justify the statement given above.
According to me for creating a Employee Management Information System of an Organisation a Database Management System(DBMS) is better then a File Management System. Drawbacks of File Management System Data Redundancy – Data redundancy refers to the duplication of data, lets Read More …
Design the Relational Schema for the E-R diagram that you have drawn for part Question 1. The relations must be at least in 2 NF. Perform the following on the relations :Identify the Foreign keys and referential integrity constraints in the relations.
In the relational databases, a foreign key is a field or a column that is used to establish a link between two tables. In simple words you can say that, a foreign key in one table used to point primary Read More …
Design the Relational Schema for the E-R diagram that you have drawn for part Question 1. The relations must be at least in 2 NF. Perform the following on the relations : Identify the Primary keys of all the relations.
A primary key is a column in a table that uniquely identifies the rows in that table. In the above ER-Diagram there are 5 Primary Key : c_code → (c_name, course_fees)Attribute c_code uniquely identifies each row in course table. So c_code is the Primary Key of Read More …
Design the Relational Schema for the E-R diagram that you have drawn for part Question 1. The relations must be at least in 2 NF. Perform the following on the relations :
b) Identify the domain of various attributes. Table Name : course Field Name Data Type Constraint Description c_code varchar(10) Primary Key Uniquely identify each course in this table c_name varchar(100) Course name course_fees int Total course fee Table Name : faculty Field Read More …
Discuss all the file organization techniques with suitable examples.
The File is a collection of records. Using the primary key, we can access the records. The type and frequency of access can be determined by the type of file organization which was used for a given set of records. Read More …
Talk to any Database Administrator (DBA) of any good s/w company and try to list all the key responsibilities that he have to handle in the said company
Functions/Roles of a Database Administrator (DBA) – Deciding the Hardware Device – Depending upon the cost, performance and efficiency of the hardware, it is DBA who have the duty of deciding which hardware device will suit the company requirement. It is Read More …
“For creating this Online Banking System as shown in Question 1, using a DBMS is better option or file management system.” Justify the statement given above.
Drawbacks of File Management System Data Redundancy – Data redundancy refers to the duplication of data, lets say we are managing the data of a Bank where a Account Holder has two Accounts. The Account Holder details in such case will Read More …
What Is Heap Sort Algorithm?
Heap Sort Heaps can be used in sorting an array. In max-heaps, maximum element will always be at the root. Heap Sort uses this property of heap to sort the array. Consider an array Arr which is to be sorted using Heap Read More …
Write An Algorithm and Program accepts the following list of integers and uses heap sort to sort and print them?
Heap Sort Algorithm In this tutorial, you will learn how heap sort algorithm works. Also, you will find working examples of heap sort in C, C++, Java and Python. Heap Sort is a popular and efficient sorting algorithm in computer Read More …
