数据库ER图SQL语言作业,英文题
来源:学生作业帮 编辑:神马作文网作业帮 分类:英语作业 时间:2024/09/23 08:29:07
数据库ER图SQL语言作业,英文题
Project 1
Project Specification
We want to create a database for a telecommunication company that provides Broadband (BB) and Home Telephone (HT) services offered through service plans.For each service plan,we need to keep the plan code,name,service type (BB or HT),description (detailed information about the service),contract period and monthly fee.
The followings are some examples of the service plans.BB stands for Broadband and HT for Home
Telephone.(见图片)
For each customer,we create a record with his/her person id,full name,contact phone number,billing address,payment method.
A customer subscribes to at least a service plan.
A subscription has a subscription ID,activation date and installation address and belongs to a single customer.
Each subscription is either a BB plan or HT plan subscription,but not both.A BB plan subscription has additional email and password attributes.A HT plan subscription has additional phone number attribute.
Every customer must select one payment method for all his subscriptions - cash or auto-pay using credit card.If the customer uses auto-pay,his/her credit card information (i.e.,card number,owner
name,expiry date) must be stored.
Tasks
1.You need to create an ER diagram for the above description.Please make your own reasonable assumptions (if any) and state them clearly.
2.Convert your ER diagram to tables.(using SQL statement)
Project 1
Project Specification
We want to create a database for a telecommunication company that provides Broadband (BB) and Home Telephone (HT) services offered through service plans.For each service plan,we need to keep the plan code,name,service type (BB or HT),description (detailed information about the service),contract period and monthly fee.
The followings are some examples of the service plans.BB stands for Broadband and HT for Home
Telephone.(见图片)
For each customer,we create a record with his/her person id,full name,contact phone number,billing address,payment method.
A customer subscribes to at least a service plan.
A subscription has a subscription ID,activation date and installation address and belongs to a single customer.
Each subscription is either a BB plan or HT plan subscription,but not both.A BB plan subscription has additional email and password attributes.A HT plan subscription has additional phone number attribute.
Every customer must select one payment method for all his subscriptions - cash or auto-pay using credit card.If the customer uses auto-pay,his/her credit card information (i.e.,card number,owner
name,expiry date) must be stored.
Tasks
1.You need to create an ER diagram for the above description.Please make your own reasonable assumptions (if any) and state them clearly.
2.Convert your ER diagram to tables.(using SQL statement)
对,明天早上第一节课交是吧,有一个思路,建立3元关系,把 customer , subscription,和service plan,这样在把属性加上,特殊的地方就是service type和payment method,可以考虑不把他们写成属性,而是写成实体,这样可以用继承的关机,把BB和HT,crash和auto_pay都设置成具体继承实体,这样可否?挺麻烦的.都是一家人,分当然给我,多谢哈,哥们儿!
数据库ER图SQL语言作业,英文题
数据库sql语言Cannot attach a database with the same name.
数据库中抽取字段的英文和数字 求sql语句
用SQL SERVER2005构建一个同义词数据库
sql数据库关系代数表达式举例问题
SQL数据库语句如何将一行变多行
求数据库设计一份.要求:需求分析,业务流程图,ER图,逻辑结构设计,物理结构设计
英语翻译本文用VC++语言开发,采用ADO技术操作数据库,在程序中通过导入ADOCom接口实现对SQL Server20
数据库的group by有什么意义呢?(sql server)
sql between and informix数据库 和其他的一样么?
问个更改SQL数据库结构额问题
数据库中两个数相除怎么写SQL语句