Introduction:This is a Software Requirements Specification (SRS) for theHospital Management System. It describes the functions, goalsand tasks that the system can perform. This is used to describethe scope of the project and to plan for the system’s design andimplementation.The following Read More …
Blog
SOFTWARE REQUIREMENTS
What is a container in C++
Standard ContainersA container is a holder object that stores a collection of other objects (its elements). They are implemented as class templates, which allows a great flexibility in the types supported as elements. The container manages the storage space for Read More …
Given the relational schema:
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 …
“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 …
