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

  Job support activity cost pools

Compute the activity rates for the Painting and Job Support activity cost pools by filling in the table below. Round off all calculations to the nearest whole cent - Prepare an action analysis report in good form of a job that involves painting 71 ..

  Machining activity cost pool

Determine the total amount of supervisory wages and factory utilities costs that would be allocated to the Machining activity cost pool.

  Demonstrate why a database was required in the first place

A narrative description of the field chosen for the application being created. This should also include a description of the problem and addressing the weaknesses to be solved by the database.

  You were hired as an analyst to develop a new information

you were hired as an analyst to develop a new information system to automate the payroll transactions in a mid-size

  Advantages and disadvantages of downloading software

Write a 700- to 1,050-word paper describing the steps involved in downloading files and programs from the Internet.

  What is lan based database management system

What is lan based database management system give an example of lan based database management system with a company name

  Explain relation schema and set of functional dependencies

Consider relation schema r(A,B,C,D,E, F) and a set of functional dependencies {A BCD,BCDE,BD,DA}. Calculate canonical cover for set of functional dependencies (show each step of your derivation with an explanation).

  Make the flowchart of the above business processes

create the flowchart of the above business processes. The assignment will be completed in 2 parts:1. AS-IS Model2.TO-BE Model once feedback is given from Professor after completing Part 1 (AS-IS Model)

  The chief financial officer

The chief financial officer (CFO) of NCWR keeps a huge number of reports, spreadsheets, and other critical financial information on his computer, which runs Windows 7

  Part 1 true or false please explain why 1 sql structured

part 1 true or false please explain why. 1 sql structured query language is both ddl data definition language and dml

  What is a foreign key constraint

Examples of non-candidate keys include the following: {name}, {age}. (Note that {gpa} can not be declared as a non-candidate key from this evidence alone even though common sense tells us that clearly more than one student could have the same grade p..

  Create a sql statement and execute the same in sqlplus

Statistics can be created on tables, indexes columns and as well as on the individual columns. But, if for some reason table or index statistics have not been updated, then this may result in a full table scan.

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