Explaining weak relationship and weak entity

Assignment Help Database Management System
Reference no: EM1346993

Q1) Within the broad "key" classification several specialized keys have been defined. List all and describe each with an example. Explain Functional dependency. Provide an example. What are entity integrity and referential integrity? Why are they considered important?

Q2) What is meant by a weak relationship? Provide an example. What is meant by weak entity? Give an example. What do you understand by relationship degree? Name and discuss the different types of relationship degree with examples.

Reference no: EM1346993

Questions Cloud

Finding the stock and debt : Suppose I am a 100% shareholder of Johnson Corporation. At the starting of 2010, My basis in Johnson Corporation stock was $14,000. During 2010, I loaned $20,000 to Johnson Corporation and Johnson Corp. reported a $25,000 ordinary business loss
Find youngs modulus for the muscle tissue : A wooden raft has a mass of 65 kg. When empty it floats in water (density 1000 kg/m3) with 41percent of its volume submerged. What mass of sand can be put on the raft without it sinking.
Memo on a communication problem : Memo on a communication problem - Explain how would you write a report in memo format to your manager about communication problem in your organization.
Developing unit costs using normal costing : The Coastal Landscaping and Snow Removal company employs normal costing to assign overhead costs to firm's various jobs. Labor is charged to jobs at $25 per hour and for upcoming winter session, overhead is estimated at $200,000 for $10,000 hours ..
Explaining weak relationship and weak entity : What is meant by a weak relationship? Provide an example. What is meant by weak entity? What do you understand by relationship degree?
Current costing model : Write down the strengths and weaknesses of current costing model.
Standard costing problem for petty petroleum : Petty Petroleum, Inc. uses various chemicals to manufacture its products. Variance data for last month for three primary chemicals used in production are as follows (F indicates a favorable variance; U indicates an unfavorable variance):
Find the amount change in the firms operating cash flow : A cost-cutting project will reduce costs by $48,500 a year. The yearly depreciation on the project's fixed assets will be $11,300 & the tax rate will be 34%.
Find the ratio of the mans kinetic energy : A wheel of diameter 5.8 cm has a 4 m cord wrapped around its periphery. Starting from rest, wheel is given a constant angular acceleration of 4.9 rad/s2. How much time it will take for the cord to unwind.

Reviews

Write a Review

 

Database Management System Questions & Answers

  Explaining controls for database to execute transaction

Controls which need a database to either execute transaction completely or not at all.

  Develop a new information system

MGMT321 Group Project :  You were hired as an analyst to develop a new information system to automate the payroll transactions in a mid-size organization. The proposed system will contain employees’ data and interface with the organization’s General ..

  Developing a database

You have been asked to develop a database utilizing only the written problem description given by the client. In reviewing the description.

  Creating database structure using sql

creating database structure using SQL

  Spreadsheet and database

Explain the differences between the storing data in Access and Excel. Why you would use a spreadsheet over the database?

  Draw the e/r diagrams for the business rules

Draw the E/R diagrams for the business rules

  Explaining software measurement related to software metrics

Is software measurement equivalent to software metrics? What makes them different?

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  An active database in pl-sql

Did the corresponding lines for invoices 1001 and 1008 in table LINE get deleted automatically? Can you explain why?

  Design a database schema

Design a Database schema

  Computing functional dependencies

Compute the functional dependencies which exist in following table. After determining the functional dependencies, transform this table to an equivalent collection of the tables which are in third normal form.

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!

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