Post your team's final exam question and answer here (1 per team) by replying to this post.
1. Explain how you can export data in an Excel format using MS Access?
To export data from a specific table in MS Access, navigate to the External Data Tab, then click on Excel and follow the wizard until the table has been exported to an Excel-readable format.
2. Explain what joins are and how you can open the database in MS Access?
Joins determine the relationship between tables in MS Access by stating the details of the relationship between two tables. You can create joins on the database tools tab or by opening a query in design view.
3. Mention how you can create a simple query in MS Access?
First, select the Create tab on the Ribbon, and locate the Queries group. Then, click the Query Design command. Next, Access will switch to the Query Design view. To write a SQL query, you must lastly, change to the SQL view by clicking on the View command and selecting SQL.
How can you create a html page in Microsoft Access? What does it give you?
You can create a static html page directly from Access by exporting your objects to an html file. This will give you a straightforward version of the data, however it will not display pictures or boolean values.
Give one advantage and one disadvantage of using NoSQL over SQL.
Advantages:
Scalability, Flexibility
Disadvantages:
Cannot predefine schema
More complicated syntax
Less likely to have ACID
Explain why SQLite is a good choice as a database engine for mobile developers and those looking to develop devices such as smart kitchen appliances?
- Being a reliable and robust database engine, SQLite lends itself to those tasks well. It requires no administration so it is a good fit for situations in which the end user is not versed in IT.
1. explain the relationship between the ER Diagram and databases.
Answer: An ER Diagram and a database are meant to mirror each other. A database serves the purpose of holding data whereas the ER Diagram serves to provide a structure to a database. They are completely separate though. If data is entered in a ER and forward engineered to be a database, the data will not transfer and the same goes if you reverse engineer a database to be an ER.
1. Explain how impedance can be avoided
An impedance mismatch can be avoided when using a NoSQL Database because such a database does not rely on relations which is the crux of this database. NoSQL databases use data stuctures such as key-value, wide column, graph, or document which do not utilize relations and therefore cannot experience the impedance mismatch.