Ask Question, Ask an Expert


Ask DBMS Expert

Home >> DBMS

problem1. Make two sample functional dependencies, one to display a single attribute primary key and one to demonstrate a multi-attribute composite key.  As well, summarize (in a sentence or two) the role and purpose of a foreign key and referential integrity.  Note any assumptions

problem2. Make an ex E/R Diagram for a fictitious business.  Consist of at least three entities.  Note any assumptions.

problem3. Convert the E/R model (created in problem #2) to a relational model.  Note any assumptions.

problem4. Demonstrate five functional dependencies which exist in the relational model (that you created in problem #2).  (Use appendix #6 as reference for this problem)

problem5. For each normal form required (1NF, 2NF, 3NF, BCNF, and 4NF), describe in a sentence the conditions which should be true in order for that normal form to be meet.

problem6. For each normal form required (1NF, 2NF, 3NF, BCNF, and 4NF), make an ex of conversion to that normal form.  (For ex, you would demonstrate the conversion from none to 1st normal form, 1st to 2nd, 2nd to 3rd normal form, and so on.  (Note (1): If you are having a difficult time creating a table which can be converted from 1st to 4th normal form, you can make multiple tables to show conversion between different normal forms.  Note (2): You are not required to know any normal form higher than 4th for this course.  Thus, you would not need to demonstrate the conversion from 4th to 5th normal form).

DBMS, Programming

  • Category:- DBMS
  • Reference No.:- M91017

Have any Question? 

Related Questions in DBMS

Database design discusion 150 wordsnormalizationplease

Database Design Discusion (150 words) Normalization Please respond to BOTH of the following questions: Question A In your own words discuss the benefits of normalization. Question B Do you think we should normalize our d ...

Discussionnormalization and redundancy please respond to

Discussion "Normalization and Redundancy" Please respond to the following: • Suggest one of the problems that normalization seeks to solve within a database. Describe one example of your suggested problem, and explain th ...

Taskoverview of business casealive amp boating aampb is a

Task Overview of business case: Alive & Boating (A&B) is a small start-up company that sells small boats in Wagga. A&B keeps its models in several showrooms across the city. At this stage customers cannot view the availa ...

Describe a dbms and its functions list at minimum three of

Describe a DBMS and its functions. List, at minimum, three of the popular DBMS products and give a brief description of each. Your response should be at least 200 words in length. Explain what mobile devices are and why ...

Problem 1 please create a plsql procedure to print out the

Problem 1: Please create a PL/SQL procedure to print out the reservation ID, checkin date, and checkout date of reservations made by a guest. The input parameters is the name of the guest. There is no output parameter. P ...

Learning outcomes1 manage user access and user profiles

Learning Outcomes 1. Manage user access and user profiles within a complex DBMS 2. Conduct database audits 3. Develop backup and recovery procedures Read the given scenario and perform all tasks. You have to answer all q ...

Create a database to keep inventory of something you own

Create a database to keep inventory of something you own, such as books, CDs, movies, collectibles, etc. You can make these up if you want. (You could use this in real life to keep track of what other people have borrowe ...

Lab creating a database designthis assignment contains two

Lab: Creating a Database Design This assignment contains two Sections: Database Design Diagram and Design Summary. You must submit both sections as separate files in order to complete this assignment. Note: If you are us ...

Suppose that you are the database developer for a local

Suppose that you are the database developer for a local college. The Chief Information Officer (CIO) has asked you to provide a summary of normalizing database tables that the IT staff will use in the upcoming training s ...

Use sql management studio to create a database called

Use SQL Management Studio to create a database called ITCO630_P1.MDF. Be sure to store the database in a location that you will remember. Add the following tables and data to the database. Use the appropriate field types ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen