Describe your idea of the database

Assignment Help Database Management System
Reference no: EM13690937

Question: This part of the assignment is a detailed project designed to help you learn the modeling of business requirements and understand the physical implementation of logical business models through the use of E-R models.

You will be adding to the course project. You will be assigned tasks each week, which you will complete and submit as directed.

Part 1-Database Planning

Imagine that you have been hired by a company to build a database for it and complete the following tasks:

Describe your idea of the database.

This can be a business problem or a hobby you are interested in-for example, an airline reservation system.

Outline the database you would like to create.

Outline the SDLC. Include the following subcategories:

Strategy and analysis for a business or an idea you plan to develop

Analysis of the current system:

What does the company have?

What business projections does it have?

Integration with other systems-plan how the current system can be integrated with other systems

Documentation and communication-describe how this vital part will be accomplished

Design for changes-prepare a plan for the future

Reusable resources-do not redo work; identify what the company has in place that you can use

You need to prepare well-formed and clean database show all of your working.

Reference no: EM13690937

Questions Cloud

Write a program which allows the user to perform simple task : Write a program which allows the user to perform simple tasks on a calculator. A series of functions allows the user to select an operation to perform and then enter operands.
Prove the equalities by induction : et S(n) = 1 + 2 + . . . n be the sum of the first n natural numbers and let C(n) = 1³ + 2³ + . . . n³ be the sum of the first n cubes - Prove the following equalities by induction on n, to arrive at the curious conclusion C(n) = S²(n) for every n. ..
Discuss the effects this kind of collaboration : Discuss the effects this kind of collaboration could have on business processes - Research commercial products (such as WebEx and LiveMeeting) available for this type of collaboration.
Describe which characteristic is most important : Suppose the characteristics of information (such as accuracy, completeness, timeliness, and relevancy) that are important to organizations. Describe which characteristic is most important for an organization with which you are familiar. Justify yo..
Describe your idea of the database : Imagine that you have been hired by a company to build a database for it and complete the following tasks - modeling of business requirements and understand the physical implementation of logical business models through the use of E-R models.
Create a gantt chart that is based on the details : Create a work plan listing the tasks that will need to be completed to meet the system's requirements - Create a Gantt chart that is based on the details of your work plan. You may use any drawing/presentation/project management tool with which you ..
Performing a feasibility analysis : How do you determine whether a project is one your development team should consider? Performing a feasibility analysis enables you to figure that out. In this Application, you use a non-IT scenario to practice this important skill.
What is the most significant risk : What project management practice, tool, or technique would be the most effective in mitigating that risk? Explain and Defend and support your opinion and cite your sources according to APA guidelines.
Develop an automated case tracking system : You are a systems development consultant who has been approached by a client, a law firm, to develop an automated case tracking system. The first step is to negotiate the project scope.

Reviews

Write a Review

Database Management System Questions & Answers

  Write a script that calculates the common factors

Write a script that calculates the common factors between 10 and 20. To find a common factor, you can use the modulo operator (%) to check whether a number can be evenly divided into both numbers.

  Decompose relation into relations which are in bcnf

it is not essential to give violations which have more than one attribute on right side. Decompose the relation, as essential, into collection of relations which are in BCNF.

  Discuss the serious data redundancy problems

Identify and discuss the serious data redundancy problems exhibited by the file structure shown in Figure and looking at the EMP_NAME and EMP_PHONE contents in Figure, what change(s) would you recommend?

  Data entities of this enterprise

Consider a student club or organization in which you are a member. What are the data entities of this enterprise? List and define each entity.

  Create a decision table that describes movement of inventory

Name four attributes that you can use to define a data flow in the grocery inventory information system.

  What does the resulting relation schema look like

Show the FDs in this resulting relation. Is it in 2NF Is it in 3NF? Why or why not? (State assumptions, if you make any.)

  Improve decision making for management

Prepare a brief of at least 1,400 words for Kudler Fine Foods management in which you address

  Er diagram that you are unable to capture in the sql

ER diagram that you are unable to capture in the SQL statements and brie?y explain why you could not express them.

  Create an rdm for each table in the erd

List all the business rules for the database for Kangaroo Inn. An example of a business rule is: "An invoice is generated by only one customer".

  Choose a suitable indicator to plot the measure

Determine how you will collect the data elements needed for this measure (i.e. how will you collect the data elements needed to calculate the measure). Describe what those data elements are, and how they will be collected.

  Explain how the web user interfaces help donors

Explain how the Web user interfaces help donors to make decisions

  You are to design a database for an insurance company the

you are to design a database for an insurance company. the data will include information about customers name address

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