Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask DBMS Expert


Home >> DBMS

For the given problem definition:

A) The university keeps track of each and every student's name, student number, social security number; current address and phone, permanent address and phone, birth-date, sex, class (freshman, sophomore, ..., graduate), major department, minor department (if some) and degree program (B.A., B.S., ..., Ph.D.). Some of the user applications require referring to the city, state, and zip of the student's permanent address and to the student's last name. Both the social security number and student number encompass unique values for each and every student.

B) Each and every department is describeed by a name, department code, office number, office phone and college. Both name and code encompass unique values for each of the department.

C) Each course consists of a course name, explanation, course number, number of semester hrs, level and offering department. The value of course number is unique for each and every course.

D) Each section consists of an instructor, semester, year, course and section number.
The section number differentiates different sections of the same course which are taught throughout the same semester/year; its values are 1, 2, 3, ...; up to the number of sections taught throughout each semester.

E) A grade report consists of a student, section, letter grade, and numeric grade (0, 1, 2, 3, 4).

Q1. Draw an E-R diagram for the above.

Q2. Map the E-R diagram to Relational Model.

DBMS, Programming

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

Have any Question? 


Related Questions in DBMS

Db questions1 what is a consistent database state and how

DB QUESTIONS 1. What is a consistent database state, and how is it achieved? 2. List and discuss the five transaction properties. 3. What is a transaction log, and what is its function? 4. What is a deadlock, and how can ...

A quick guide to pivot tables is found at the end of this

A "Quick Guide to Pivot Tables" is found at the end of this document. Review it BEFORE beginning the questions. The data for this exercise (structured as a flat file) can be found in an Excel workbook located on Blackboa ...

Database worksheetuse the attached database to complete the

Database Worksheet Use the attached database to complete the following: Create a simple excel spreadsheet with data to update the database. >>> This can hold any type of data to be used in this database In MS Access 1. C ...

Database relationsusing the invoice table structure shown

Database Relations Using the INVOICE table structure shown in Table, do the following: ATTRIBUTE NAME SAMPLE VALUE SAMPLE VALUE SAMPLE VALUE SAMPLE VALUE SAMPLE VALUE INV_NUM 211347 211347 211347 211348 211349 PROD_NUM A ...

In general my report talks about the database management

In general, my report talks about the Database management system. But I want to a specific topics of it in 3 pages. The topics are: 1. Comparison between File approach and Database approach. 2. Advantages and disadvantag ...

Physical database design assignment query optimisationthis

Physical Database Design Assignment: Query Optimisation This assignment aims to develop your skills optimizing query. It involves identifying the suitable methods for structuring the data and writing the query. First, yo ...

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

1 objective named entity recognitionin this project you

1. Objective: Named Entity Recognition In this project, you will use scikit-learn and python 3 to engineer an effective clas- sifier for an important Information Extraction task called Named Entity Recognition. 2. Gettin ...

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

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

  • 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