Skip to main content

BCA 206 DATABASE MANAGEMENT SYSTEM CONCEPTS

By
  •  What is logical view of data?
  •  Explain what are relation and their characteristics in detail?
  • What are keys? How it is useful to Controlled redundancy?
  • Explain integrity rules
  • Explain relation set operators
  • Explain joins in detail
  • What is data dictionary and System Catalog?
  • Explain relationship with relational database
  • What are indexes?
  • Explain the following
    • Single Valued Attribute
    • Multi Valued Attribute
    • Simple Attribute
    • Composite Attribute
    • Derived Attribute
  • What is connectivity and cardinality?
  • What is Existence Dependency?
  • Explain Weak Entity, ID-Dependent Entity
  • What is Composite Entities?
  • What two condition must be met before an entity can be classified as a weak entity? Give an example of a weak entity.
  • What is a strong relationship? And how it is depicted in a crow’s foot ERD?
  • What is recursive relationship? Give an example
  • What is composite Entity?
  • Discuss two ways in which the 1:M relationship between course and class can be implemented.
  • How would you identify each of the following ERM components in a Crow’s Foot Model?
    • An entity
    • The cardinality
    • A weak relationship
    • A strong relationship
  • Explain the difference between single-valued and simple attribute. Give an example
  • Draw ER Diagram for following problem
  •    



Comments

Post a Comment

Popular posts from this blog

Data Held for Ransom in 70 Countries; Massive Cyber Attack Hits Russia Hard

By
London:  A huge extortion cyberattack hit dozens of nations Friday, holding computer data for ransom at hospitals, telecommunications firms and other companies. The attack appeared to exploit a vulnerability purportedly identified for use by the US National Security Agency and later leaked to the internet. The attack hit Britain's health service, forcing affected hospitals to close wards and emergency rooms. Related attacks were reported in Spain, Portugal and Russia. Two security firms — Kaspersky Lab and Avast — said they had identified the malware behind the attack in upward of 70 countries, although both said the attack has hit Russia hardest. The Russian Interior Ministry has confirmed it was hit by the "ransomware" attack, which encrypts data on infected computers and demands payment, usually via digital currency bitcoin, to release it. Britain's health service was also hit hard Friday as the attack froze computers at hospitals across the country, ...
Post a Comment
Read more
By
The board of Snapdeal is expected to meet tomorrow to discuss the potential sale of India's third largest e-commerce firm to larger rival Flipkart. Also, on the agenda will be getting Nexus Venture Partners (NVP), an early investor in Snapdeal, to agree to the sale deal. The seven-member board of Jasper Infotech, which operates Snapdeal, includes representation from investors SoftBank, Kalaari Capital and Nexus Venture Partners (NVP), as well as co-founders Kunal Bahl and Rohit Bansal. The valuation of Snapdeal is believed to be one of the hurdles to the deal, as Kalaari and NVP were not in agreement with the valuation given by SoftBank, which is the largest shareholder in Snapdeal. SoftBank has now succeeded in getting Kalaari (another early-stage investor in Snapdeal) to agree but is yet to get NVP on board for the deal. The sources said once NVP agrees, the deal with Flipkart could be announced in a matter of weeks. The deal with Flipkart, if it happens, would...
Post a Comment
Read more