Solution-Can you say that attribute b defnitely is or is

Can you say that attribute b defnitely is or is not a key

Assignment Help Database Management System

Reference no: EM13509384

Consider a relation R that has three attributes ABC. It is decom-posed into relations R1 with attributes AB and R2 with attributes BC.

1. State the definition of a lossless-join decomposition with respect to this example. Answer this question concisely by writing a relational algebra equation involving R, R1, and R2.

2. If you are given the following instances of R1 and R2, what can you say about the instance of R from which these were obtained? Answer this question by listing tuples that are de?nitely in R and tuples that are possibly in R.

Instance of R1 = {(5,1), (6,1)} Instance of R2 = {(1,8), (1,9)}

Can you say that attribute B de?nitely is or is not a key for R?

Reference no: EM13509384

Questions Cloud

Compute the orbital period of the faster planet : Two newly discovered planets follow circular orbits around a star in a distant part of the galaxy. What is the orbital period of the faster planet

Determing the amount of total dividends : On january 1 2004 a corporation issued 25000 shares of %10 $50 par cumulative preferred stock and 50000 shares of $30 par common stock. Cash dividends declared by the board were as follows.

Outline and explain the concept of internal marketing : Outline and explain the concept of internal marketing and why it is important in service products. How would you introduce an effective internal marketing programme to an organisation?

What is the ending noncontrolling interest balance : Apart from its investment in Starr, Harrison had income of $220,000 in 2011 and $260,000 in 2012.

Can you say that attribute b defnitely is or is not a key : State the defnition of a lossless-join decomposition with respect to this example. Answer this question concisely by writing a relational algebra equation involving R, R1, and R2.

Calculate fica social security taxes payable : Calculate FICA Social Security taxes payable and FICA Medica taxes payable. Prepare the journal entry to record Royal Company's January 8 (employee) payroll expenses and liabilities.

Describe the system of legal responsibilities among share : Describe the system of legal responsibilities among shareholders

What are the journal entries for dec 31 portion : The Mchenry company purchased a truck for 54,000 on Jan 4, 2010. Paid $275.00 in Feb for oil change Dec 31 record the depreciation on the truck for the fisical year. The estimated useful life of the truck is 8 years witha residual value of $12,000..

Prepare the december 2009 journal entries to record : Prepare the December 2009 journal entries to record the newsstand sales and subscriptions received. (assume that the debit is to cash)

User Account

All Pages

Can you say that attribute b defnitely is or is not a key

Reference no: EM13509384

Reference no: EM13509384

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