Ask Question, Ask an Expert


Ask DBMS Expert

Home >> DBMS

Answer all the problems.

Central University runs from its main campus and a number of associated colleges. University has a number of programmes ranging from Diploma (1 year duration), Bachelor’s degree (3 or 4 year’s duration), Post Graduation (2 to 3 years duration) and research degree programmes (2-3 years duration). Structure of each programme is approved centrally. A programme might be offered through main campus or associated college. Students are registered centrally in the programme and college of his/her choice. Fee is also paid centrally yearly. The final data of admission could be obtained by colleges through a query to central database. University has a centralized examination system. It conducts examination of the students in different courses of various programmes. For simplicity you might suppose that the programme of the University only have three compulsory courses in a year. Do the following tasks for the University. Make and state assumptions, if any.


Name the entities, their attributes and relationships for description and make the ER-diagram for the University. You might use the concept of keys, aggregation, generalisation, cardinality etc. in a appropriate way.


Design the appropriate RDBMS tables for the ER-diagram so created in problem 1. Database design must include keys, foreign keys, constraints and referential integrity constraints.


Implement database design which you have created in problem 2 using a RDBMS – our advice is that you select either MySQL or MS ACCESS to do so.


Create the following data entry form with appropriate checks for the database so created.

a) Form for Entry of student information such as enrolment number, name, father’s name, date of birth, programme code (it must be from a list of valid programmes), year of programme, and draft number (for fee).

b) Form for entry of examination results of a course submitted by an examiner. It must be noted that examiners are sent printed examination sheet called mark list for each subject. Mark list contains printed enrolment number and name of the students and a blank column for entering the marks. A mark list is sorted in the order of enrolment numbers.


Enter at least 4 sets of records in each table. Enter marks directly in the tables except for the data which could be entered using the data entry form created in problem 3.       


Create the following reports for the database you have created. The reports must have proper headings and page numbers and must include totals, if required.           

a) Create list of students of a college. This list must be sorted in the order of programme and enrolment numbers in that programme.

b) Create the attendance list for a subject in a college.

c) Print mark list of a subject that requires to be verified.

d) Create result card for a student.


prepare and run the following SQL queries for your database:                     

a) Determine the details of the programme having maximum number of students.

b) Determine the programme which has the maximum fee. Also find the number of students enrolled in this programme.

c) Determine the student who have either failed the subject Database Management System at least once or has not given the examination for this subject. You might suppose that this subject is taught in BCA 2nd Year and MCA 1st year.

d) Determine the student who has topped in BCA 2nd Year examination.

e) Determine the number of programmes run in each college.


Design two views for the database which you have designed and implemented. One view must be for the University Vice Chancellor who is interested in knowing about performance of students in different programme and colleges. The other view is for a student who could view only his/her information. Identify on what tables and what fields these two would be allowed to have access. Implement these views or prepare equivalent queries for the view defining expression using SQL.

DBMS, Programming

  • Category:- DBMS
  • Reference No.:- M92346

Have any Question? 

Related Questions in DBMS

Application creating and populating a databasesuppose you

Application: Creating and Populating a Database Suppose you have a small retail store and decide to create a database to track sales. You have information about recent sales that you want to use for testing the database. ...

Database individual assignmentdesign a database entity and

Database: Individual Assignment Design a database (entity and relationship tables in Access) for a small college department library. You should have the entities and relationships you need to support: Purchase books Sell ...

Part 1identify and explain the default logins or user

Part 1 Identify and explain the default logins or user accounts for one of the database vendors discussed in the chapter. Part 2. Case Project 6-1: Database Password Policies, page 199 Create and document a written passw ...

Your assignment should be submitted in a single word doc

Your assignment should be submitted in a single Word doc (.doc or .docx). It should include your scenario diagram for Problem 1, and your Ruby source code for Problems 2 and 3. Contact me or post to our discussion board ...

Coit20247 database design and development assignmentyou

COIT20247 Database Design and Development Assignment You must use that sample solution of assignment only for the following tasks: Assessment task- 1. Normalization a) Map the ERD, from the sample solution, into a set of ...

Data mining is a powerful and tool but it poses challenges

Data mining is a powerful and tool, but it poses challenges to the protection of individual privacy. Data mining can combine information from many sources to create detailed profiles about each of us. Explore the Web sit ...

Design a relational database for a video rental store the

Design a relational database for a video rental store. The store, which rents only DVDs and has no sales other than DVD rentals, has approximately 5,000 customers and approximately 1,200 DVD titles. There are 25 supplier ...

The purpose of the veterinary hospital registration system

The purpose of the Veterinary Hospital Registration system is to handle and record all the information relating to the clients, veterinarians, pets, treatments administered, insurance coverage and appointments (open, clo ...

Project guidelinesoverviewthe final project for this course

Project Guidelines Overview The final project for this course is the creation of a database proposal and implementation plan report that will address the needs of a given scenario. The purpose of this assessment is to as ...

Brief-the aim is that your team should produce a

Brief- The aim is that your team should produce a requirements document that describes the problem to be solved and captures the requirements for an information system that supports the needs of the vehicle pool manager ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

A cola-dispensing machine is set to dispense 9 ounces of

A cola-dispensing machine is set to dispense 9 ounces of cola per cup, with a standard deviation of 1.0 ounce. The manuf

What is marketingbullwhat is marketing think back to your

What is Marketing? • "What is marketing"? Think back to your impressions before you started this class versus how you

Question -your client david smith runs a small it

QUESTION - Your client, David Smith runs a small IT consulting business specialising in computer software and techno

Inspection of a random sample of 22 aircraft showed that 15

Inspection of a random sample of 22 aircraft showed that 15 needed repairs to fix a wiring problem that might compromise

Effective hrmquestionhow can an effective hrm system help

Effective HRM Question How can an effective HRM system help facilitate the achievement of an organization's strate