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

Replacement china incproject descriptionyou work as an

Replacement China, Inc. Project Description: You work as an associate database manager at Replacement China, Inc. This firm specializes in finding difficult-to-replace, no-longer manufactured china, crystal, silver, and ...

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

Here is two assignment one is only summery of project from

Here is two assignment one is only summery of project from first assignment, in powerpoint. pleasedont copy and paste, it will be verified by software for plagiarism. please cite all sources by APA format. due date is 26 ...

Describe a dbms and its functions list at minimum three of

Describe a DBMS and its functions. List, at minimum, three of the popular DBMS products and give a brief description of each. Your response should be at least 200 words in length. Explain what mobile devices are and why ...

Discussionnormalization and redundancy please respond to

Discussion "Normalization and Redundancy" Please respond to the following: • Suggest one of the problems that normalization seeks to solve within a database. Describe one example of your suggested problem, and explain th ...

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

Consider a typical sales invoice that would include the

Consider a typical sales invoice that would include the following information. Design a single table to hold all of the information required to store an invoice including this information. Next, apply normalization to re ...

Warehouse management system projectproject deliverablesthe

Warehouse management system project Project Deliverables The project requires students to perform three phases: (a) requirements analysis, (b) system and database design, and (c) a project plan. Note that in the phase 3, ...

The use of an access database has become very common over

The use of an Access database has become very common over the last 10 years. Access is the preferred desktop database because server databases such as structured query language (SQL) and others are too complex and are be ...

Database design discusion post and assignmentdiscusion post

Database Design Discusion Post and Assignment Discusion Post: Data as a Corporate Resource and Foreign Keys Please respond to BOTH of the following questions: Question A Discuss how data can be a corporate resource and d ...

  • 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