如何开始设计SQL表

本文介绍了如何开始设计SQL表的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述 29岁程序员，3月因学历无情被辞！ 请问我如何设计SQL表，请给我一个如何开始的想法。我是技术新手。我需要紧急帮助 我需要设计这些表First Table 客户Please How I can design SQL tables,Please give me Idea for that How to start.I am new on technology.please i need urgent helpI need to design these tables First TableCustomerUnique IdMandatoryNameMandatoryFirst NameMandatoryMiddle NameOptionalLast NameOptionalEmailIdMandatoryMobile#MandatoryTelephone#MandatoryFax#OptionalCredit LimitOptionalCredit DaysMandatoryUadjusted AmountMandatoryIsActiveMandatoryBill AddressOptionalShip AddressOptionalTotal BalanceMandatoryContact Person NameMandatoryOpening BalanceMandatoryCreated DateTimeMandatoryModify DateTimeMandatoryINACTIVE_DATE Optional 第二个表发票Second table InvoiceUnique IdMandatoryInvoice#MandatoryInvoice Amount in Home CurrencyMandatoryInvoice Amount in Foreign CurrencyMandatoryInvoice DateMandatoryDue DateMandatoryExchange RateMandatoryCurrencyNameMandatoryBalance Amount in Home CurrencyMandatoryBalance Amount in Foriegn CurrencyMandatoryCustomer IdMandatoryCustomerNameMandatoryPurchase Order#OptionalPurchase Order DateOptionalSalesPerson NameOptionalTransaction TypeMandatoryIsPaidOptionalCreated DateTimeMandatoryModify DateTimeMandatory 第三表供应商Third Table VendorUnique IdMandatoryNameMandatoryFirst NameMandatoryMiddle NameOptionalLast NameOptionalEmailIdMandatoryMobile#MandatoryTelephone#MandatoryFax#OptionalCredit LimitOptionalCredit DaysMandatoryUadjusted AmountMandatoryIsActiveMandatoryBill AddressOptionalShip AddressOptionalTotal BalanceMandatoryContact Person NameMandatoryOpening BalanceMandatoryCreated DateTimeMandatoryModify DateTimeMandatoryINACTIVE_DATE Optional 第四个表帐单fourth table BillUnique IdMandatoryBill#MandatoryBill Amount in Home CurrencyMandatoryBill Amount in Foreign CurrencyMandatoryBill DateMandatoryDue DateMandatoryExchange RateMandatoryCurrencyNameMandatoryBalance Amount in Home CurrencyMandatoryBalance Amount in Foriegn CurrencyMandatoryVendor IdMandatoryVendor NameMandatoryPurchase Order#OptionalPurchase Order DateOptionalSalesPerson NameOptionalTransaction TypeMandatoryIsPaidOptionalCreated DateTimeMandatoryModify DateTimeMandatory 第五表收据Fifth table ReceiptUnique IDMandatoryReceipt # or Adjustment ReferenceMandatoryReceipt DateMandatoryInvoice #MandatoryInvoice DateMandatoryReceipt Amount In Home CurrencyMandatoryExchange RateMandatoryReceipt Amount in Foreign CurrencyMandatoryCustomer IdMandatoryCustomer NameMandatoryReceipt TypeMandatoryCreated DateTimeMandatoryModify DateTimeMandatory 我们需要这些表但是如上所述我看到有customerId和CustomerName是Invoice表和收据表的引用，与invoceNo，InvoiceDate相同。 .......所以我修好了我需要为此创建超过5张桌子吗？ 任何人都可以给我一个合适的请注意这个想法。 因为我告诉我这项技术的新手。 我尝试过： 我还没有启动任何东西，我只需要一个想法，如果我为CustomerId，Customername创建一个表，并使主键用于参考其他表,,,和InvoiceNo和InvoiceDate一样........ 请为此我需要您的紧急帮助。we need these tables but as above i am seeing that there are customerId and CustomerName is references for Invoice table and receipt table same as for invoceNo, InvoiceDate,........so i am fix will I need to create more than 5 tables for that?can anyone give me a suitable Idea for that please.as i told I am new on this technology.What I have tried:I did not start anything yet, I need just an idea if i create a table for CustomerId, Customername and make primary key for taking references other table,,,same as for InvoiceNo and InvoiceDate and so........please i need your urgent help for that.推荐答案呃......是的。您不会在任何论坛环境中获得有关如何执行此操作的完整教程。你真的需要学会以正确的方式做到这一点。我强烈建议你在SQL Server上学习一本初学者书并完成它。 为了做到这一点，这不是你要在一对夫妇身上学到的东西小时。Uhhh...yeah. You're not going to get a full tutorial on how to do this in any forum environment. You really need to learn to do this the proper way. I highly suggest picking up a beginners book on SQL Server and working through it.To do this properly, this is not something you're going to learn in a couple of hours.你好， 你需要花一些时间来学习sql基础知识的第一件事。 请点击此链接如何在sql server中创建表格 [在sql server中创建表格] 要添加一个constrait，请关注直到part10视频，最多一个小时就不会花费太多时间。 以下是步骤：处理你的数据。 1）首先创建一个数据库。 2）添加具有标识和数据类型的表格。 3）添加约束映射表。 4）你没有提到数据类型（数字，varchar，日期时间，货币）检查你的团队。 谢谢 ：）Hi ,The First Thing you need to spend some time to learn basics on sql.please follow this link how to create a tables in sql server[Create a tables in sql server]To add a constrait please follow untill part10 videos and it won't take much time max one hour is enough.Here are the steps to do with your data.1) Create a database first.2) Add Tables with Identity and data type.3) Add constraints to mapping tables.4) you didn't mentioned datatype(number,varchar,Datetime,Currency) check with your team.Thanks:) 这篇关于如何开始设计SQL表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！ 上岸，阿里云！