## Description
#### A final exam project from 3rd semester Database course at University of Latvia. The aim of the project is to create a database for cinema company with all details starting from creating database with SQL, inserting data to database tables, creating modes such as physical, logical and conceptual models, retrieving data from database.
## Content
- Database Design
- SQL Queries
- Conceptual Model
- Physical Model
- Logical Model
## Examples from project
- Database design with sql (creating tables and inserting data)
![SQL 2](https://user-images.githubusercontent.com/66011783/114092781-f36cc000-98c2-11eb-8e2b-4b8a3a642965.PNG)
![SQL 3](https://user-images.githubusercontent.com/66011783/114092792-f7004700-98c2-11eb-8094-1107444f8233.PNG)
- Sql queries (retrieving data, joining tables)
![Queries](https://user-images.githubusercontent.com/66011783/114092746-e94ac180-98c2-11eb-9653-09e32aabacbe.PNG)
- Conceptual model
![Conceptual Model (Chen Syntax)](https://user-images.githubusercontent.com/66011783/114092920-1eefaa80-98c3-11eb-92b5-a285178bdce5.png)
- Physcial model
![Physical Model](https://user-images.githubusercontent.com/66011783/114092997-3af34c00-98c3-11eb-8720-58b0c470469c.png)
- Logical model
![Logical Model](https://user-images.githubusercontent.com/66011783/114093028-46467780-98c3-11eb-8112-61ee9264c654.png)
计算机毕设工作室
- 粉丝: 985
- 资源: 77
最新资源
- comsol模拟不同形状晶粒的煤体、岩体、土体的水力压裂、煤层压裂相场本构模型,内含不同尺寸的骨料、晶粒 案例文件众多,包含不
- 电脑DLL文件修复工具
- C 语言实现直流电机PI控制输出占空比示例代码
- GNURadio实现的QPSK信号调制.grc工程
- 有限控制集模型预测控制两电平三相并网逆变器 控制采用代码编程实现 输出电流电压波形如下所示~
- C语言控制结构详解:顺序结构、选择结构和循环结构
- comsol焊接热源模型 双椭球热源、高斯旋转体热源、柱状体热源等
- GNURadio实现的4FSk信号调制.grc工程
- 基于java的人事管理系统,前端是用vue
- 自适应滑膜观测器估计轮胎纵向力和侧向力,可提供免费讲解与carsim 联合仿真,估计结果可作为汽车行驶状态滤波器的输入代替轮胎模
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈