Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

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.

problem1)                       

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.

problem2)                            

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.

problem3)                        

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.

problem4)                                    

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.

problem5)      

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.       

problem6)  

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.

problem7)

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.

problem8) 

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

Objective this is an individual assignment aimed to give

Objective: This is an individual assignment aimed to give the student exposure in understanding, designing, building and analyzing database systems for a given real-time based scenario and be able to conduct optimal stra ...

Data analysis assignment- apriori analysis and cluster

Data Analysis assignment- ApriorI analysis and Cluster analysis CLUSTER ANALYSIS The purpose of this assignment is to demonstrate steps performed in a K-Means Cluster analysis. Review the "k-MEANS CLUSTERING ALGORITHM" s ...

1 what is the most popular database model2 how are primary

1. What is the most popular database model? 2. How are primary and foreign keys different? 3. What are the five important software components of a database management system? 4 What are the four major types of data-minin ...

Discussion questionsdatabase programs are used to store and

Discussion Questions Database programs are used to store and to retain data for a variety of applications, and are often used in conjunction with Web content to deliver dynamic Web pages. Please respond to all of the fol ...

Learning outcomes1 manage user access and user profiles

Learning Outcomes 1. Manage user access and user profiles within a complex DBMS 2. Conduct database audits 3. Develop backup and recovery procedures Read the given scenario and perform all tasks. You have to answer all q ...

Project database and programming designthis assignment

Project: Database and Programming Design This assignment consists of two sections: a design document and a revised Gantt chart or project plan. You must submit both sections as separate files for the completion of this a ...

Lab creating a database designthis assignment contains two

Lab: Creating a Database Design This assignment contains two Sections: Database Design Diagram and Design Summary. You must submit both sections as separate files in order to complete this assignment. Note: If you are us ...

Learning outcomes1 manage user access and user profiles

Learning Outcomes 1. Manage user access and user profiles within a complex DBMS 2. Conduct database audits 3. Develop backup and recovery procedures Read the given scenario and perform all tasks. You have to answer all q ...

Objective this is an individual assignment aimed to give

Objective: This is an individual assignment aimed to give the student exposure to the concepts relating to database systems and optimal strategies for efficient management of databases Learning Outcomes assessed: 1. Crea ...

1 analyse situations andor environments for the application

1) Analyse situations and/or environments for the application of database solutions including web connectivity 2) Create, alter and remove relational tables, indexes and data using an appropriate database language. 3) Ex ...

  • 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

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen