Solution-Describe the entity-relationship model

Describe the entity-relationship model

Assignment Help Database Management System

Reference no: EM13329211

Entity-Relationship (ER) Model

Composite and multi-valued attributes can be nested to any number of levels.

Suppose we want to design an attribute for a STUDENT entity type to keep track of previous college education. Such an attribute will have one entry for each college previously attended, and this entry is composed of: college name, start and end dates, degree entries (degrees awarded at 2 that college, if any), and transcript entries (courses completed at that college, if any). Each degree entry is formed of degree name and the month and year it was awarded, and each transcript entry is formed of a course name, semester, year, and grade. Design an attribute using the General notations to hold this information.

Reference no: EM13329211

Questions Cloud

What is the passengers weight : It takes the elevator in a skyscraper 4.5s to reach its cruising speed of 12m/s. What is the passenger's weight before the elevator starts moving

Find out the number of valence electrons : Determine the number of valence electrons in each of the following elements. Ta Fe Cs

Show an alternative design using the general notations : Show an alternative design using the General notations for the attribute described in Problem 2 that uses only entity types (including weak entity types if needed) and relationship types.

How to calculate the molar mass of the unknown gas : A gas of unknown molecular mass was allowed to effuse through a small opening under constant-pressure conditions. It required 67 s for 1.0 L of the gas to effuse. Under identical experimental conditions it required 24 s for 1.0 L of O2 gas to effu..

Describe the entity-relationship model : Composite and multi-valued attributes can be nested to any number of levels.

What will be your total accumulated money in the end of year : If you deposited $1,000 with an Annual interest Rate of 16% with 12 Compounding Periods Per Year (M) in the total of 6 Compounding Periods (Years). What will be your total accumulated money in the end of 6 years

Find the electric flux through the surface of the box : Charges of 3.0 nC, -2.0 nC, -7.0 nC, and 1.0 nC are contained inside a rectangular box with length 1.0 m, width 2.0 m, find the electric flux through the surface of the box

Draw the er diagram using industral-style notations : Each department is described by a name, department code, office number, office phone, and college. Both name and code have unique values for each department.

Evaluate the equilibrium constant ka for the acid : Calculate the equilibrium constant, Ka for the acid, HA if, at equilibrium, the pH of a 2.3 M solution of HA is 1.62

User Account

All Pages

Describe the entity-relationship model

Reference no: EM13329211

Reference no: EM13329211

Questions Cloud

Reviews

Write a Review

Database Management System Questions & Answers

Knowledge and data warehousing

Design a database schema

Entity-relationship diagram

Implement a database of courses and students for a school

Prepare the e-r diagram for the movie database

Design relation schemas for the entire database

Prepare the relational schema for database

Data modeling and normalization

Use cases perform a requirements analysis for the case study

Knowledge and data warehousing

Stack and queue data structure

Practice on topic of normalization

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT