作业帮 > 英语 > 作业

英语翻译8.For example,a customers tablemight store one customer

来源:学生作业帮 编辑:作业帮 分类:英语作业 时间:2024/05/10 12:47:27
英语翻译
8.
For example,a customers tablemight store one customer per row.The number of rows in the table is the numberof records in it.Row A record in atable.Records or Rows?You may hearusers refer to database records when referring to rows.For the most part,thetwo terms are used interchangeably,but row is technically the correct term.Primary Keys Every row in a table shouldhave some column (or set of columns) that uniquely identifies it.A tablecontaining customers might use a customer number column for this purpose,whereas a table containing orders might use the order ID.An employee listtable might use an employee ID or the employee social security numbercolumn.This column (or set of columns)that uniquely identifies each row in a table is called a primary key.Theprimary key is used to refer to a specific row.Without a primary key,updatingor deleting specific rows in a table becomes extremely difficult as there is noguaranteed safe way to refer to just the rows to be affected.Always Define Primary Keys
例如,一个客户tablemight每行存储一个客户.表中的行数是它的一些记录.在一行记录.记录或行吗?你可能hearusers引用数据库记录时参照的行.在大多数情况下,这两个词可以互换使用,但排在技术上是正确的术语.主键的表中的每行有一些列(或列)唯一地标识它.一个tablecontaining客户可能使用客户编号列为了这个目的,而一个表包含命令可以使用命令ID.员工listtable可能使用一个雇员ID或雇员的社会保障numbercolumn.此列(或列)唯一标识表中的每一行称为主键.的主要重点是指一个特定的行.没有一个主键,updatingor删除特定表中的数据变得非常困难,因为有noguaranteed安全的方式仅指行受到影响.总是定义主键