Databases

Winery Database Creation:

The assignment covered an introduction to database creation by incorporating the opportunity to undertake basic research on the Internet, basic database design, and for the use of the introduction to Microsoft Access software. The knowledge gained from the following assignment established the importance of database creation and basic table designs, the understanding of advanced characteristics of tables and their relationships, and the crucial role databases play in the organization of data.

Click the document below to download the Winery Database.

Winery Database Use and Application:

The purpose of the following assignment served as an introduction to creating multiple database applications involving making queries, forms, reports within Microsoft Access. The knowledge gained from the assignment included learning how to create queries to retrieve useful information, understand how to build forms and reports with full functionality, as well as understand the form level controls and user controls, and lastly, understand application creation and security. It also taught the crucial role database applications (queries, forms, and reports) play in the organization of data, how data is displayed or presented to the user, and the advanced characteristics of Microsoft Access, showing how powerful the software is and what it can do.

Click the document below to download the Winery Database.

Winery Database T-SQL:

The purpose of the following assignment was to compose the SQL statements using Transact-SQL (T-SQL) standard in Microsoft SQL Server environment. The knowledge gained from the assignment included learning how to create a winery database in Microsoft SQL Server using SQL statements. It also taught how to write various SQL statements to answer numerous questions in order to get an executed result.