Consider the data of the following two tables. Department DepartmentID DName ContactNo 1 UIIT 0300-1234567 2 UIMS 0300-4567891 Student RollNo Sname Fname DepartmentID 111 Ali Ahmed 1 112 Sana Waqar 2 113 Afzal Ikram 2 There are only two departments and are already initialized globally, but students can be upto 100 and just defined globally. To maintain how many student’s record have been entered you can use global variable with name as count. Write a C++ program having: Structures, structure definitions and required initializations for the above scenario. Function which takes input data (RollNo, Sname, Fname and DepartmentID) of student from user within the function, then verify that the DepartmentIDexists in Department or not? If exists then copy DName and ContactNo in the student record along with above input, otherwise just display a message that department does not exists. For example the following record will not be allowed to store in the Student table because departmentID 3 instance is not available in the department table. 115 Farooq Bilal 3 Function which displays number of students in each department in the following format, note that you should be the first student in UIIT and your data should be displayed in first row (Add screen shot of your output): Total Student Enrolled: 03 Students enrolled in UIIT: 02 Student enrolled in UIMS: 01 Seats Vacant: 100-03=97 RollNo Sname Fname DName ContactNo YourNo YourSname YourFname UIIT 0300-1234567 112 Sana Waqar UIMS 0300-4567891 113 Afzal Ikram UIIT 0300-1234567

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

Consider the data of the following two tables.

Department

DepartmentID	DName	ContactNo
1	UIIT	0300-1234567
2	UIMS	0300-4567891

Student

RollNo	Sname	Fname	DepartmentID
111	Ali	Ahmed	1
112	Sana	Waqar	2
113	Afzal	Ikram	2

There are only two departments and are already initialized globally, but students can be upto 100 and just defined globally. To maintain how many student’s record have been entered you can use global variable with name as count. Write a C++ program having:

Structures, structure definitions and required initializations for the above scenario.
Function which takes input data (RollNo, Sname, Fname and DepartmentID) of student from user within the function, then verify that the DepartmentIDexists in Department or not? If exists then copy DName and ContactNo in the student record along with above input, otherwise just display a message that department does not exists. For example the following record will not be allowed to store in the Student table because departmentID 3 instance is not available in the department table.

115

Farooq

Bilal

Function which displays number of students in each department in the following format, note that you should be the first student in UIIT and your data should be displayed in first row (Add screen shot of your output):

Total Student Enrolled: 03

Students enrolled in UIIT: 02

Student enrolled in UIMS: 01

Seats Vacant: 100-03=97

RollNo	Sname	Fname	DName	ContactNo
YourNo	YourSname	YourFname	UIIT	0300-1234567
112	Sana	Waqar	UIMS	0300-4567891
113	Afzal	Ikram	UIIT	0300-1234567

Expert Solution

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions