SQL relational database system Apk

SQL relational database system Apk

Latest version 1.51
11 Dec 2022

Older Versions

Apk Infos

Version1.51
Rating4.5/5, based on 11 votes
Size‎1012.2 KB
Requires AndroidAndroid 4.0+ (Ice Cream Sandwich)
Author's NotesSQL RDBMS Relational Database Management System (ATABASE)

About SQL relational database system APK

SQL relational database system APK Download for Android
SQL relational database system APK Download for Android

Description

If you use Android 6 Marshmallow or above, enable memory access permission
manually for this appplication to run in task manager mode, please!
Otherwise this application can't run normally in Marshmallow.
No problems to run in other Android OS.

SQL RDBMS (ATABASE), the SQL relational database management system
complex application for Android OS provides the next:

- Creating any simple or complex relational dabases
- Renaming or delete databases
- Runing any simple or very complex SQL queries
- Calculation any complex mathematical expressions in SELECT queries
- Creating VIEWs in databases by any SQL SELECT queries
- Browsing any table of a database as a table form
- Browsing any VIEW of a database as a table form
- Backuping and restoring any database
- Importing CSV files into new tables in a database (Windows 1251 code page for now)
- Exporting tables of databases as CSV files (Windows 1251 code page for now)
- Checking out any databases structure (tables and VIEWs)
- Checking out any tables structures in any databases
- Checking out SQL SELECT queries content of any VIEW
- SQL queries templates list provided for quick learn SQL and to try
- SQL Script Master mode to run any SQL script file and check the execute result list
- SQL queries constructor mode to simplify the design SQL queries process
- Up to 100 last successfull SQL commands save list to retry and memory
- Scripting database modes to script database structure, data of a database or database in whole
- Primary key consdtraint check for all data types
- SQL join RELATIONAL ALGEBRA for join tables on all types of colums data
- Reporting and sharing reports created of VIEWs data sets
- Creating charts of VIEWs numeric data sets for visual qualitative representation
- Creating normalized data BAR,GRAPH and PIE charts of any numeric column data of a VIEW.
- TIME and DATE types components in WHERE logical expressions use.
- Multi level ordering feature for all types of columns and for any component of DATE and TIME types.
- Multi level grouping feature for all types of columns and for any component of DATE and TIME types
- Unusual use of universal function LIKE in WHERE logical expressions. See WEB site for explanations.


Data types supported in columns of tables are:

int - integer
pkint - integer with primary key constraint check
numeric - real number (with dot)
pknumeric - real number (with dot) with primary key constraint check
varchar - any string data as 'This is string data'
pkvarchar - any string data with primary key constraint check
date - date like 'yyyy.mm.dd', 'yyyy/mm/dd', 'yyyy-mm-dd' where yyyy - year, mm - month, dd - day number
pkdate - date with primary key constraint check
time - time as 'hh:mm:ss' where hh - hour, mm - minute, ss - second
pktime - time with primary key constraint check
picture - same as varchar with '.jpg', '.png', '.bmp' at the end of string like 'Picture1.jpg'
pkpicture - picture with primary key constraint check

Primary key constraint check for column of a table is check for uniqueness
of data for that column in the table. That rule is for every column with
primary key constraint check but not for column data combinations constraint chect
if two or more colums have primary key constraint in this application.

Mathematical functions available are:
PI() - pi number
E() - e number
RANDOM() - random number
ASIN() - arc sinus
ASIN() - arc cosinus\
ATAN() - arc tangent
SIN() - sinus
COS() - cosinus
TAN() - tangent
CBRT() - cubic root
SQRT() - square root
exp2() - square exponent
exp() - natural exponent
log10() - base 10 logarithm
log() - natural logarithm
abs() - absolute value
degrees() - convertion into degreess
radioans() - convertion into radians
rint() - round into integer
round() - round double presision number
ceil() - truncate into whole integer
floor() - truncate
sign() - convert double presision natural number into integer 1 with a sign

Latest updates

What's new in version 1.51

You can append records into your database tables directly by user interface.
Select your database, go to SQL, Structure. Then select table and browse it or append new records.

How to install SQL relational database system APK on Android phone or tablet?

Download SQL relational database system APK file from ApkClean, then follow these steps:

Update Phone Settings

  • Go to your phone Settings page
  • Tap Security or Applications (varies with device)
  • Check the Unknown Sources box
  • Confirm with OK

Go to Downloads

  • Open Downloads on your device by going to My Files or Files
  • Tap the APK file you downloaded (atabase.complex-v1.51-ApkClean.apk)
  • Tap Install when prompted, the APK file you downloaded will be installed on your device.

Older Versions

1.51 (51)1012.2 KB

Questions & Answers

Q: What is an APK File?

A: Just like Windows (PC) systems use an .exe file for installing software, Android does the same. An APK file is the file format used for installing software on the Android operating system.

Q: If I install an APK from this website, will I be able to update the app from the Play Store?

A: Yes, absolutely. The Play Store installs APKs it downloads from Google's servers, and sideloading from a site like ApkClean.net goes through a very similar process, except you're the one performing the downloading and initiating the installation (sideloading).
As soon as the Play Store finds a version of the app newer than the one you've sideloaded, it will commence an update.

Q: Why ApkClean.net can guarantee APK 100% safe?

A: Whenever someone wants to download an APK file from ApkClean.net, we'll check the corresponding APK file on Google Play and allow user download it directly (of course, we'll cache it on our server). If the APK file does not exist on Google Play, we'll search it in our cache.

Q: What are Android App permissions?

A: Apps require access to certain systems within your device. When you install an application, you are notified of all of the permissions required to run that application.

Don't hesitate to contact us if you have any questions or concerns.

(*) is required

User's Reivew

5 ★Excellent App for RDBMS
5 ★So fine app