User Account

All Pages

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

Reviews

Write a Review

Database Management System Questions & Answers

  Explain normal form is denormalized table

Which field or fields cause a table to no longer be in third normal form? In which normal form is denormalized table?

  Identify each relationship type and write all of the busines

Identify each relationship type and write all of the business rules and create the bask Crow's Foot ERD for DealCo.

  Assume the data warehousing system is centralized

Assume the data warehousing system is centralized, and implemented in the environment of Microsoft SQL Server 2012. As we discussed in the introduction, each store has its own local database.

  Prepare fully attributed data model

Use the results of the transcripts of an interview with IT consultant. Prepare a Fully Attributed Data Model. Add the data attributes for each entity."

  Generate a database diagram

For each of these statements, include a screenshot of the SQL. Make sure to include the statement execution, including the resulting data. Display all columns and all rows from the Employees table.

  The packing list describes the ideal contents

The packing list describes the ideal contents of each package, but it is not always possible to include the ideal number of each item. Therefore, the actual items included in each package should be tracked. A package can contain many different ite..

  Create a report which identifies five most expensive bicycle

Create a report which identifies five most expensive bicycles. The report must list bicycles in descending order from most expensive to lease expensive, the quantity on hand for each, and the markup percentage for each.

  Explain data for each candidate of eight constituencies

supplies % of votes each candidate is likely to receive, based on popularity rating. Actual number of votes received is that percentage of General votes. You should enter data for each candidate in each of the eight constituencies.

  Use of data definition language-data manipulation language

Pick one of the different types of SQL statements (data definition language, data manipulation language, or data control language). Describe how that type of statement is use.

  Convert the erd

Using the descriptions of the attributes given in the, convert the ERD shown in Figure P6.2 into a dependency diagram that is in 3NF.

  Make a spreadsheet to compare e-commerce sites

create a spreadsheet to compare the three identified e-commerce hosting sites and the e-commerce hosting site that you find • prepare a PowerPoint presentation that represents the presentation you would give to management explaining your selection..

  Writing down sql query

Write down the SQL code in order to carrying out the following requests. Display all the data in each of the four tables. Do not display the foreign key columns.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd