Database management systems are key element of information technology systems that are used on a day-to-day basis by many organizations . The keys to using a database management system are to collect the necessary requirements for the database, translate these requirements into a database design, create the database from the design, load data into the database, and finally to perform manipulations of the database. The purpose of this final assignment is to ensure that you understand and can carry out the necessary tasks in order to manage a sample database.
1. Selection of a database. 2. Identifying the requirements for the database based on the purpose for the database and the data to fill the database. 3. Create a database design based on the requirements for the database, create the physical database, and load data into the database. 4.
You are to turn in a word document that contains a series of screen captures that contain the results of an SQL statement. The word document will contain multiple pages, each page containing one or more screen captures associated with the prompt.
Enrolling in a course lets you earn progress by passing quizzes and exams.
When MySQL Workbench loads, the Schemas displays on the left-hand side of the window.