#Navicat data modeler student pdf#

Subqueries - create 5 sample queries (select) for the database containing subqueries.Join - create 5 sample queries (select) for the database containing joins.Queries with functions - create 10 sample queries (select) for a database containing various functions (numeric, aggregate, character, dates).Normal - create 5 sample queries (select) to the database.

Operations on data - creating SQL scripts related to completing data in tables so that there are at least 5 rows in each table, additionally presenting an example of modification and deletion of data in tables,.changing the name of the table, columns, removing columns, etc. Operations on tables - creation of 5 sample SQL scripts related to operations on tables, e.g.Creating a relational database based on the project - scripts creating the database.table patient - store data about patient of your clinic, ID - identification number of patient, primary key of this table, name - name of the patient. Description of tables and columns in these tables - description of what will be stored in the columns (eg.Relational database schema - Physical database model (tables, columns, data types, connections between tables).database should work fast - we get query results in less then 1 second) Non-functional requirements - list of non-functional requirements of the user (eg.database enable to add, edit and delete data about patients) Functional requirements - list of the user's functional requirements (eg.Description of the reality fragment - we describe in words a fragment of reality for which we will design the database (minimum 0.5 A4 page).

#Navicat data modeler student pdf#

Send project on pdf file to: This email address is being protected from spambots.