构建复杂的DB需要设计帮助 [英] Building a complex DB need design help

问题描述

大家早上好，

我正在尝试为我正在创建的数据库布置设计。如果我能得到一些建议和帮助那就太棒了。我正在尝试为小型跳伞中心创建一个数据库。

I am trying to lay out the design for a DB I am creating. If I could get some advice and help that would be great. I am trying to create a database for a small Skydive Center.

 

需要

追踪客户，学生，跳线，员工。跟踪成本和认证日期。 每个身份将具有不同的信息和共同的信息。

Track Customers, students, jumpers, staff. Tracking cost and dates of certifications.  Each identity will have different information with common info.

Common

首先，姓氏，地址， city，state，zipcode，Waiver（布尔）

First, last names, Address, city, state, zipcode, Waiver (Boolean)

学生

什么类别通过了许多需要检查的技能，豁免（布尔）。毕业后，他们成为跳线

What Category passed lots of skills that need to be check off, Waiver (Boolean). After graduation they becomes jumpers

需要追踪当天结束时的跳款和服务欠款。

Need to track money owed at the end of the day for jumps and services.

跳线

会员编号和到期日期，许可证编号，保留包日期。跳线可以成为教练

Membership number and expiration date, License numbers, reserve pack dates. Jumpers can become instructors

需要跟踪当天结束时跳转和服务所欠的钱。

Need to track money owed at the end of the day for jumps and services.

教练

所有跳伞运动员信息，教练评级，医疗日期，制造评级和日期。

All skydiver Info, Instructor ratings, medical dates, manufacture ratings and dates.

需要跟踪资金在一天结束时欠跳跃和服务。此外还有业务所欠的服务。

Need to track money owed at the end of the day for jumps and services. Also what is owed from business for there services.

表结构

推荐答案

这是一个好的开始。

That is a good start.

你真的可以发布CREATE TABLE吗？

Can you actually post CREATE TABLEs?

只需按照简单的例子： 
http://www.sqlusa.com/bestpractices2005/bankdatabase/

Just follow the simple examples:  http://www.sqlusa.com/bestpractices2005/bankdatabase/

这篇关于构建复杂的DB需要设计帮助的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！