Difference between revisions of "Databases"

From Sinfronteras
Jump to: navigation, search
Line 1: Line 1:
==Terminology of relational model==
 
 
A database is an organized collection of data. It is the collection of schemas, tables, queries, reports, views, and other objects. https://en.wikipedia.org/wiki/Database
 
A database is an organized collection of data. It is the collection of schemas, tables, queries, reports, views, and other objects. https://en.wikipedia.org/wiki/Database
  
  
* What is the primary key: '''title_id'''
+
<br />
* What is the foreign key: '''Pub_id'''
+
==[[Database design]]==
* What is the cardinality: '''13'''
 
: <span style="color:#FFFFFF; background:#000000"> select  count(title_id) as 'Cardinality of the «titles» table' from titles; </span>
 
* What is its degree: '''9'''
 
* What is the domain of contract: '''Smallint(6) NOT NULL'''
 
  
* What is the domain of ''country'' in the table ''Publishers'': '''varchar(15) NOT NULL'''
 
  
 +
<br />
 +
==[[MySQL]]==
  
  
==[[MySQL]]==
+
<br />
 +
==[[PostgreSQL]]==
  
  
 
<br />
 
<br />

Revision as of 21:55, 19 June 2020

A database is an organized collection of data. It is the collection of schemas, tables, queries, reports, views, and other objects. https://en.wikipedia.org/wiki/Database



Database design


MySQL


PostgreSQL