Developing a Database for a Café

What is the first step in understanding the problem for developing a database for the café?

• Designing the user interface

• Identifying stakeholders

• Setting up the database

• Conducting integration testing

Which of the following is NOT a typical requirement to gather during the initial stage?

• Data to be stored

• Café’s workflows and processes

• Programming languages to be used

• Existing systems and tools used by the café

In the decision-making stage, what is a crucial factor to determine?

• The layout of the café

• The type of database (relational or Flat file)

• The color scheme of the website

• The café’s menu design

What is an example of a relational database that could be used for the café?

• MS Access Database management system

• MongoDB

• Cassandra

• Redis

What should be prioritized when making decisions about features and functionalities?

• The café’s physical location

• Importance to the café’s operations

• The developer’s preferences

• The café’s interior design

What type of data would be stored in the MenuItems table?

• Menu item details like name, description, price, and category
• Weather forecasts
• Employee salaries
• Customer addresses

During the implementation stage, what is a crucial task?

• Sketching the user interface

• Performing unit testing

• Writing server-side code for data operations

• Conducting interviews with café staff

Which field would be used as a primary key in the Customers table?

• CustomerID
• CustomerEmail
• CustomerName
• CustomerPhone

What is the purpose of user testing the new system?

• To write the initial code for the database

• To optimize queries and indexes

• To have café staff use the system and gather feedback

• To create the database schema

What should be done during the performance evaluation of the database?

• Writing unit tests

• Monitoring database performance under various loads

• Conducting user interviews

• Designing the user interface