Normal T No Spac.. Heading 1 Heading 2 Paragraph Styles 1. A GUI database that c

Question

Normal T No Spac.. Heading 1 Heading 2 Paragraph Styles 1. A GUI database that coukd be made woukd be for an auto repair shop to implement a symptoms database mixed with their parts inventory/database in. order to better serve customers. A customer could choose from a list of symptoms within their car anda breakdown of possible parts that could need changing. From there, the database will narrow the list to the possible parts it could be and see if they are in stock. Depending on the results, the body shop could make an appointment based on the results and either make a full appointment to fix the issue or if the part shows not in stock, they could make a quick appointment to simply diagnose the issue and order the part if necessary 2. This app would be web-based, utilized on both a desktop version and a mobile version for Linux, Android, Windows, and ios 3. The main requirements for this database would be using java within html in.order to use the system across multiple platforms in browsers 4. The system would start out with a question such as "do you have a specific request or an issue that needs diagnosing?" in which the user picks an options and either picks something specific such as inspection or oil change. After each selection, they can choose to add another option or finish. If they chose the diagnosing option, it wouid simply give multiple choice questions in which the user can give more specific symptoms and the issue will be narrowed down or they could simply skip to the end with the information provided. The person would end up getting a ticket number and told a representative would call them based on the information given Answer the following What DBMS, data provider, high-level language, and data API would you use to provide the required features and functionality? Why? Be specific Using Visio or Dia (one of which you installed previously) and following the sample in this week's reading, create a mockup for the requested user interface. Write a paragraph explaining your design choices

Explanation / Answer

Solution :

Well, what Database Management System is used, it actually depends on the fact that the amount of data we have the number of transaction counts or hit we will be getting in future etc.

In the broader aspect if we talk about the DBMS selection, we should first know how many there are actually to serve this problem statement. So, popular Databases are as follows:

Now, above all i will definitely go with the oracle DB as its the number DB company which provides alot of methods to access the databases. But there is another database which can also be used to solve the same problem, i.e.

NO-SQL (Non-Relational and Distributed Data) :-

If your data requirements aren’t clear at the outset or if you’re dealing with massive amounts of unstructured data, you may not have the luxury of developing a relational database with clearly defined schema. Enter non-relational databases, which offer much greater flexibility than their traditional counterparts. Think of non-relational databases more like file folders, assembling related information of all types. If a wordpress blog used a NoSQL database, each file could store data for a blog post: social likes, photos, text, metrics, links, and more.

There are many Unstructured data from the web can include sensor data, social sharing, personal settings, photos, location-based information, online activity, usage metrics, and more. Trying to store, process, and analyze all of this unstructured data led to the development of schema-less alternatives to SQL. Taken together, these alternatives are referred to as NoSQL, meaning “Not only SQL.” While the term NoSQL encompasses a broad range of alternatives to relational databases, what they have in common is that they allow you to treat data more flexibly.

How do NoSQL databases work? Instead of tables, NoSQL databases are document-oriented, This way, non-structured data (such as articles, photos, social media data, videos, or content within a blog post) can be stored in a single document that can be easily found but isn’t necessarily categorized into fields like a relational database does. It’s more intuitive, but note that storing data in bulk like this requires extra processing effort and more storage than highly organized SQL data. Thats why hadoop is capable of processing huge amounts of data in the cloud, is so popular in conjunction with NoSQL database stacks.

NoSQL databases offer another major advantage, particularly to app developers: ease of access. Relational databases have a fraught relationship with applications written in object-oriented programming languages like Java, PHP, and Python. NoSQL databases are often able to sidestep this problem through APIs, which allow developers to execute queries without having to learn SQL or understand the underlying architecture of their database system.

As in this case, Oracle will be more efficient enough to solve the problem.

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.