Businesses of every size organize data records into collections called databases
ID: 3918931 • Letter: B
Question
Businesses of every size organize data records into collections called databases. The purpose of a database is to keep track of things. At one extreme, small businesses use databases to keep track of customers; at the other extreme, huge corporations use databases to support complex sales, marketing, and operations activities.
Suppose that a county planning department wants to build a new database system to keep track of building permit applications for both residential and commercial projects. The database should be available to the applicants over the Internet. You have been hired as a consultant to recommend the best strategy for creating such a database.
In an well-formed essay, address each of the following in your recommendation:
What requirements would you need to collect from the stakeholders before proposing your solution? **Hint – these will drive your decisions on all of the following items
What type of database (would you use MS Access, Oracle, etc.)? Explain why you are using the approach you select
Storage location – Would this be on site? What about virtual? Explain reasoning
Based on storage location, what would the client have to buy, setup?
Who manages the database? What skills do they need?
Is it able to scale? (i.e., what if company quickly grows? What if we hit another recession?)
Be sure that your paper:
Is in APA Format
Includes a cover page and page numbers
Has a reference page and in line text citations - no assignments will be accepted without any sources cited.
Explanation / Answer
1. What type of database? Explain why you are using the approach you select.
Answer: SQL Server because it is best to manage database and it provides easy User Interface for managing the data.
It provides Easy connections to other developing software like Visual Studio, Android Studio and etc.
So, if in future need for developing a software is required to manage the database of company for employees to manage it without having the information the sensitive data in database.
2. Storage Location- Would this be on site? What about virtual? Explain reasoning based on storage location, what would the client have to buy, setup?
Answer: Storage location should be virtual and only if client are allowed to buy online because that will keep the track of the units of items available in storage.
This will make managing of storage of item easy.
A website will required to be developed for online services you want to provide which can be developed by a Web designer or Web developer as per the requirement to make it easy for client to purchase item from your company.
There should be a need of Server to make a Website live for client to access it and that server needs to be managed by a server manager who would have the skills in networking to keep your website online , manages the website also and safe from hacker, attackers and spams.
3. Who manages the database? What skills do they need?
Answer: A DBA (Database Administrator) will manage the database because it a DBA has skills in database management like knowledge in SQL query language, PLSQL, Data Structure and etc.
A DBA has roles like to make sure that data in database is secure, if ever system crashes then recovery of database, fix any errors in occurs, constantly maintenance of database and other things related to a database.
4. Is it able to scale?
Answer: yes it can because of the DBA handling the database he/she can make any changes required to make the database working according to company.
Due to database having the company’s information like storage, employees and etc.
So, DBA can make changes using that data to make it work when company grows or goes in recession.
DBA can provide company with analysis of the database to help with the budget of the company or marketing or financial or any decision making related company.
Which will help the company to able to make the best descision for their best interest.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.