![](https://img-blog.csdnimg.cn/20201014180756923.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
数据库
为你千千万万遍z
这个作者很懒,什么都没留下…
展开
-
pgsql数据库作业练习4-5
感觉这些题大部分都是比较基础的,所以以后就放一些做的时候有卡壳的,和有多种解法的一些题~建表语句都放在最后了,可供练习~练习4框架题目及解答-- 4.5 Select all data from all movie theaters -- and, additionally, the data from the movie that is being shown in the theater (if one is being shown).SELECT * FROM movies J原创 2021-04-02 14:37:06 · 362 阅读 · 0 评论 -
pgsql数据库作业练习3
框架建库建表语句-- The Warehouse-- lINK: The_warehouseCREATE TABLE Warehouses ( Code INTEGER NOT NULL, Location VARCHAR(255) NOT NULL , Capacity INTEGER NOT NULL, PRIMARY KEY (Code) );CREATE TABLE Boxes ( Code CHAR(4) NOT NULL, Contents原创 2021-03-31 22:11:37 · 187 阅读 · 0 评论 -
pgsql数据库作业练习2
框架建库建表语句-- LINK : Employee_management------------------------------------------- Build the Schema-----------------------------------------CREATE TABLE Departments ( Code INTEGER PRIMARY KEY, Name varchar(255) NOT NULL , Budget decimal NOT NUL原创 2021-03-31 00:53:01 · 163 阅读 · 0 评论 -
pgsql数据库作业练习1
框架建库建表语句-- LINK: The_computer_store-- RDBMS: postgrescreate database db1;\c db1;CREATE TABLE Manufacturers ( Code INTEGER, Name VARCHAR(255) NOT NULL, PRIMARY KEY (Code) );CREATE TABLE Products ( Code INTEGER, Name VARCHAR(255) NOT原创 2021-03-30 23:01:21 · 170 阅读 · 0 评论 -
[转载]最简单的数据库“范式”教程
转载自https://blog.csdn.net/yangbodong22011/article/details/51619590转载 2021-03-23 20:12:26 · 84 阅读 · 0 评论