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

Case problem-global site gps - kevin hodge is a production

Case Problem- Global Site GPS - Kevin Hodge is a production assistant at Global Site GPS, a leading manufacturer of GPS devices located in Crestwood, Missouri. One of Kevin's jobs is to monitor output at the company's fi ...

Create a database to keep inventory of something you own

Create a database to keep inventory of something you own, such as books, CDs, movies, collectibles, etc. You can make these up if you want. (You could use this in real life to keep track of what other people have borrowe ...

Career opportunities in your majorknowledge workers

CAREER OPPORTUNITIES IN YOUR MAJOR Knowledge workers throughout the business world are building their own desktop databases (often called end-user databases or knowledge worker databases). To do so, they must understand ...

A task descriptionoverviewyour task is to create and test a

A. Task Description Overview Your task is to create and test a database in MySQL using PhpMyAdmin. You are provided with a scenario and supporting documents, describing the requirements that Southern Cross University may ...

Database analysis and designimplement the initial database

Database Analysis and Design Implement the initial database design for the Enterprise Resource Planning conceptual model described by the following requirements in your selected RDBMS. You need to create the Entity-Relat ...

Assignmentyou are to design a program that will serve as a

Assignment You are to design a program that will serve as a database for keeping track of video games and various statistics for the games. This application will allow for the storing of the name of a video game, its gen ...

Oracle databaseusing the schema you developed in homework 1

Oracle Database Using the Schema you developed in Homework 1 for your e-Commerce project, design and implement a Virtual Private Database that limits database access. Your design should be based on two of your columns an ...

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 ...

Option simulation preparation paperby the end of module 2

Option : Simulation Preparation Paper By the end of Module 2, you will have received the URL, team name (also known as logon ID), and password for the Littlefield Simulation site from your instructor. This week, you must ...

  • 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

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

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