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

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

Homeworkunlimited pickers is a group of workers who have

Homework Unlimited Pickers is a group of workers who have joined together to provide harvesting services to farmers who need to have their crops brought in. The organization has many teams of workers who travel from loca ...

How up-to-date should data warehouse information

HOW UP-TO-DATE SHOULD DATA WAREHOUSE INFORMATION BE? Information timeliness is a must in a data warehouse-old and obsolete information leads to poor decision making. Below is a list of decision-making processes that peop ...

Relational databases theory and practice assignmentanswer

Relational databases: theory and practice Assignment ANSWER ALL QUESTIONS Question 1 - Use the block notes to answer the following questions: i. Explain what is meant by the process of denormalization and how it is done. ...

The strayer oracle server may be used to test and compile

The Strayer Oracle Server may be used to test and compile the SQL Queries developed for this assignment. Your instructor will provide you with login credentials to a Strayer University maintained Oracle server. A multina ...

Use sql management studio to create a database called

Use SQL Management Studio to create a database called ITCO630_P1.MDF. Be sure to store the database in a location that you will remember. Add the following tables and data to the database. Use the appropriate field types ...

Data warehouses and data martswrite a one- to two-page

Data Warehouses and Data Marts Write a one- to two-page (250-500 word) paper that discusses the differences between data warehouses and data marts. Also, discuss how organizations can use data warehouses and data marts t ...

Assignmentas the new manager of a convenience store you

Assignment As the new manager of a convenience store, you have noticed issues with the manual method of tracking sales using paper sales tickets and spreadsheets, as well as, shortages on some of the more popular items c ...

Your team is a consulting company that specializes in rapid

Your team is a consulting company that specializes in rapid application development. A client company wishes to improve their customer data and interactions records. You create a simple customer relationship system for t ...

Problem 1 please create a plsql procedure to print out the

Problem 1: Please create a PL/SQL procedure to print out the reservation ID, checkin date, and checkout date of reservations made by a guest. The input parameters is the name of the guest. There is no output parameter. P ...

  • 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