What is a data model and what is it purpose

Assignment Help Database Management System
Reference no: EM13707286

Name the three stages in the process of developing database system summarize the tasks in each?

Answer the given questions and also justify your answers with proper examples

Question 1: What is a data model and what is it purpose?

Question 2: What is a prototype and what is its purpose?

Question 3: What is a use case, and what is its purpose?

Question 4: Provide an example of a data constraint .?

Question 5: Provide an example of a business rule that would need to be documented in a data base development project?

Question 6: Define the term entity and give an example other than those used in this book?

Question 7: Explain the difference between an entity class and an entity instance.?

Question 8: Define the term attribute and give examples for the entity you described in question 4.7?

Question 9: Define the term identifier and indicate which attribute defined in your answer to question 4.9 identifies the entity?

Question 10: Define the term composite identifier and give an example other than those used in this book?

Question 11: Define the term relationship and give an example other than those used in this book?

Question 12: Explain the difference between a relationship class and a relationship instance?

Question 13: Define the term degree of relationship and give an example other than one used in this text of a relationship greater than degree two .?

Question 14: Define the term maximum cardinality and minimum cardinality ?

Question 15: Explain the ambiguity in the definition of the term weak entity .explain how this book interprets this term.?

Please give a detailed answer so that I may learn from it. Thank you!

Reference no: EM13707286

Questions Cloud

Find the sum and difference for numbers : Write a program that prompts the user for two numbers, finds the sum and difference for those numbers and displays a descriptive label for each computation by calling two different functions. Use Function Prototypes.
What does the execute bit mean for a directory : What does the 'execute' bit mean for a directory? Show how the execute bit works for referencing files within directories. Does the execute bit need to be set for ANY directory on the path to a file you wish to reference?
Representing an investment value and interest rate : Write a Java test program, all your code should be in the main method that asks the user for two numbers representing an investment value and interest rate.
Prepare a new int[] variable and inititialize it : Prepare a new int[] variable and inititialize it to be a new int array with the given size to create random values use the random class import javautil.random inside the method create a new instance with: Random rand = new Random();
What is a data model and what is it purpose : What is a data model and what is it purpose and what is a prototype and what is its purpose - What is a use case, and what is its purpose?
Can you find the element of an array : We would like to determine whether a given array A has a majority element, and if so, find the element.
Prepare a program that takes the data from triangle : Prepare a program that takes the data from triangle.txt (supplied in this folder) and outputs a message indicating whether the triangle is a right triangle. The text file has data for three triangles.
Explain exothermic reaction that is nonspontaneous : Question- Which of the following is consistent with an exothermic reaction that is nonspontaneous at high temperatures?
Iron(iii) ion with three c2o42- ions attached as ligands : Question- A compound contains a transition metal coordination complex. This coordination complex consists of one iron(III) ion with three C2O42- ions attached as ligands. Which formula below describes a compound that fits this description?

Reviews

Write a Review

Database Management System Questions & Answers

  Optimize the query in the select script using alter table

optimize the query in the select script using Alter Table to add appropriate indexes. Also use Optimize and Explain to show how the performance of this query has improved.

  Create a function

Create a function that returns the day of the week for a specified date. Create a trigger that displays the message "Emp table updated" when an update to the employee table increases the employee's basic salary.

  Based on the schema write sql statements

Based on the schema write SQL statements and provide the equivalent relational algebra expressions - relational algebra expressions return and give the equivalent SQL statements.

  Write three items contained in fat database

What does CHS stand for? List three items contained in the FAT database. List two features NTFS provides that FAT does not.

  Create a data dictionary

Construct a query that will show the number of days that exist between the first invoice and last invoice, for each month, for each employee, using the DATEDIFF function. Be sure to provide the SQL script that will carry out this function.

  Metropolitan city church managementmetropolitan city church

metropolitan city church managementmetropolitan city church management mccm has hired you as a consultant to modernize

  Implementation of virtual private databases

Prepare a 3-4 pages of technical document in MS Word Format on usage, utilization, and implementation of Virtual Private Databases (VPD) for the cases of your choice.Explain each situation in details, and describe how it works?

  Describe the various network implementations

The marking scheme, which is given in detail below, particularly rewards the way in which you relate your specific proposals to the material presented in the Course.

  What is the cost of joining r and s using a sort-merge join

What is the cost of joining R and S using a page-oriented simple nested loops join? What is the minimum number of buffer pages required for this cost to remain unchanged?

  Ways of implementing one-to-one relationships

Describe the difference ways of implementing one-to-one relationships. Assume you are maintaining information on offices (office numbers, building, and phone numbers)

  Create data warehouse for electronics store chain

Create a data warehouse for electronics store chain. Chain has 20 stores in 5 cities. Each store has different sections comprising computers, DVDs, TVs, audio, home appliances etc.

  Systems analysis and database designyou should back up your

systems analysis and database designyou should back up your answers with theoryreferences from reliable sources - more

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