Distinctions among terms primary - candidate and super key

Assignment Help Management Information Sys
Reference no: EM131248859

Q.1 What are the drawbacks of using file system over database management system?

Q.2 Explain the distinctions among the terms primary key, candidate key, and super key.

Q.3 Consider the bank database.

branch(branch name, branch city, assets)
customer (customer name, customer street, customer city)
loan (loan number, branch name, amount)
borrower (customer name, loan number)
account (account number, branch name, balance)
depositor (customer name, account number)

Give an expression in the relational algebra for each of the following queries:

a. Find all loan numbers with a loan value greater than $50,000.

b. Find the names of all depositors who have an account with a value greater than $9,000.

c. Find the names of all depositors who have an account with a value greater than $8,000 at the "Uptown" branch.

Q4: Consider the advisor relation shown in Figure 2, with s_id as the primary key of advisor.

Suppose a student can have more than one advisor. Then, would s_id still be a primary key of the advisor relation? If not, what should the primary key of advisor be?

2212_advisor.png

Schema Diagram for University Database.

Reference no: EM131248859

Questions Cloud

Develop annotated bibliography to indicate quality of source : Develop an annotated bibliography to indicate the quality of the sources you have read. For each annotation, you need to summarize in your own words how the source contributes to the solution of the global societal issue.
How many of the apps listed on the website do you have : Do some brief Internet research to see the information that "Pokemon Go" captures when using the software. What are your thoughts about providing access to this information being gathered by the developers? After reading all this, are you more or les..
How many as have mod 10 inverses : How many a's have mod 10 inverses? (Uniqueness) - Show that if a and m are relatively prime, then the inverse of a mod m is unique.
Comprehensive marketing plan researching : Marketing Plan This week you will continue your comprehensive marketing plan researching the SAME company that you researched in previous units. Again, utilizing the CSU Online Library, you will research the various elements of the marketing plan ..
Distinctions among terms primary - candidate and super key : Find all loan numbers with a loan value greater than $50,000. Find the names of all depositors who have an account with a value greater than $9,000. Find the names of all depositors who have an account with a value greater than $8,000 at the "Uptown"..
General method for determining c and d in such a cipher : Show that the message can be recovered by an affine transformation of the form and determine the constants c and d.
How darwin theories altered the socio cultural landscape : After reading Charles Darwin's "Natural Selection" from The Origin of Species, write a paper that speculates how Darwin's theories altered the socio cultural landscape of the late 19th Century
Liquidated damages clause : How would the court determine whether the liquidated damages clause is valid? Is this clause valid? Explain your answers. Cite any direct quotes or paraphrased material from outside sources. Use APA format.  Information about accessing the grading ru..
What is the general procedure for finding the number : Encoding single letters one by one is rather limiting, since there are only 26 possible messages. - What is the general procedure for finding the number corresponding to a digraph?

Reviews

Write a Review

 

Management Information Sys Questions & Answers

  Convince the audience that this would benefit their business

Based on what you have learned about using social media in today's enterprises, prepare a 5-slide presentation to a department head or the CEO of a company to convince the audience that this would benefit their business.

  Suggestion of atm-like machines to improve delivery options

Write a well presented report for the above outlining the business operation. Do not use any trademarked restaurant name in your report -  Provide suggestions into improving business service

  Need for information systems competitive edge in leading

need for information systems competitive edge in leading retailersit is believed that the competitive edge of leading

  Major goals for the information technology strategic plan

Develop at least five (5) major goals for the information technology strategic plan. Justify your response. Speculate on three (3) positive organizational impacts of implementing the strategic plan. Justify your response

  Explain a technology innovation

This post addresses health technology issues - Explain a technology innovation that can change/ease an inefficient visit at a medical facility experienced by you or a family member

  Role of it in organizations that compete globally

Discuss whether or not backcasting is an important concept for addressing major forces that shape the role of IT in organizations that compete globally. Explain your answer

  Federal information security management act

What were the advances in information technology that resulted in new ethical issues necessitating the creation of each act, Federal Information Security Management Act

  What is the difference between a project risk and an issue

Define the difference between Business Process Re-engineering (BPR) and Business Process Management (BPM) concepts. What are the advantages and disadvantages of BPM? How do "value chain" principles apply to BPR and BPM? Why should an IT manager kn..

  Versions of the jwdconsulting case study

After reading chapter three (THE PROJECT MANAGEMENT PROCESS GROUPS: A CASE STUDY), discuss the main differences between the two versions of the JWDConsulting case study

  Integration of e-commerce and erp system

ASSIGNMENT - Integration of E-commerce and ERP system with other ICT (information and communication technologies) to create value for customer and shareholders

  Defining data relationshipsdefining data relationships is

defining data relationshipsdefining data relationships is an important process during the database design. discuss the

  Identify the source of inefficiency in the lemons model

Under what sort of market conditions would this quote apply? Connect this quote to Akerlof's lemons model.- Among other things, use this quote to help identify the source of inefficiency in the lemons model.

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