[SQL Server] roject-jsp-sqlServer-TaichungCityUrbanDevelopment
台中市都市發展局-都市設計服務網
Taichung Urban Development Bureau - Urban Design Service Network (2024-01-29, Others, 0KB, 下载0次)
[SQL Server] Nashville_Housing_Market_Project
在这个项目中，我采取原始的纳什维尔住房市场数据，并在SQL Server中执行各种SQL查询和数据清理技术，以确保…
In this project I take raw Nashville housing market data and perform various SQL queries & Data Cleaning techniques in SQL Server to ensu… (2024-01-10, Others, 0KB, 下载0次)
[SQL Server] ETLProjectSSIS
这是我使用AdventureWorksDW2022和WideWorldImporters数据集的SQL Server Integration Services（SSIS）上的ETL项目。成就：连接创建、变量创建、容器创建、数据转换、查找、派生列创建、聚合和排序、连接和条件拆分、多播和缓变维度
This is my ETL Project on SQL Server Integration Services (SSIS) using the AdventureWorksDW2022 and WideWorldImporters datasets. Achievements: connection creation, variable creation, container creation, data conversion, lookups, derived column creation, aggregations and sorting, joins and condition splits, multicast and slow changing dimesion (2023-12-29, Others, 0KB, 下载0次)
[SQL Server] daima
此为建库和查询代码
针对 了解数据库和 数据库实验使用
逻辑结构设计
将E-R图转换成关系模式：
管理员（编号，账号，密码，权限）
房 间（编号，类型，价格，状态，入住客户编号）
客 户（编号，姓名，性别，年龄，身份证号，住址，入住时间，预计天数，房间编号，退房时间，押金，住宿费，登记人）
管理员房间管理（管理员编号，房间编号）
管理员客户管理（管理员编号，客户编号）
This is the code for building a database and query the database and the database to understand the logical structure of experimental design will use the ER diagram into relational schema: manager (number, account number, password, permission) rooms (number, type, price, status, check account number) Customer (ID, name, sex, age, ID number, address, Check, expected number of days, room number, check-out, deposit, accommodation, registration person) room management administrator (administrator ID, room number) management member of client management (administrator number, customer number) (2011-06-12, Others, 1KB, 下载3次)
[SQL Server] zhaopin
在线人才招聘系统，分为个人用户和企业用户两个，个人可填加个人信息，求职意向，企业里有企业的信息，可以双向选择
Online Recruitment system, divided into individual users and business users two, individuals can fill in additional personal information, job search intention, enterprises have business-related information, can be two-way selection (2008-06-07, Others, 639KB, 下载59次)