数据库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 n

来源:学生作业帮助网 编辑:六六作业网 时间:2024/12/24 13:04:18
数据库ER图SQL语言作业,英文题Project1ProjectSpecificationWewanttocreateadatabaseforatelecommunicationcompanythat

数据库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 n
数据库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)

数据库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 n
对,明天早上第一节课交是吧,有一个思路,建立3元关系,把 customer , subscription,和service plan,这样在把属性加上,特殊的地方就是service type和payment method,可以考虑不把他们写成属性,而是写成实体,这样可以用继承的关机,把BB和HT,crash和auto_pay都设置成具体继承实体,这样可否?挺麻烦的.都是一家人,分当然给我,多谢哈,哥们儿!

数据库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 n 做数据库er图的步骤 数据库sql语言Cannot attach a database with the same name. 数据库填空题1.数据库是长期存储在计算机内、有组织的、可_ _的数据集合.2.数据库的三级模式是指内模式、___________________、外模式.3.SQL语言支持关系数据库的三级模式结构,其中外模式对应 数据库SQL的英文音标怎么读?请高手给写出来. 数据库:题目上给了一个er图,根据图写出数据库的表结构来. 求PRO-E作业! 如何定义中文标题的相似度?现需要找出数据库中标题相似的文章,可以如何用SQL语言定义中文标题的相似度? desc 在sql语言中是什么意思 英文全称应该是什么呢? 【求SQL 语句】 数据库表中 xlzm这一列的内容中有很多中文的括号,怎样批量替换成英文括号, 数据库中两个数相除怎么写SQL语句 数据库的group by有什么意义呢?(sql server) 什么是“SQL数据库环境”?请问下哪个专家,什么是“SQL数据库环境”?是不是所有的电脑都具有的? sql = select pro_out.*,pro.name from pro_out left join pro on pro_out.pro_id=pro.id 英文数据库有哪些 ER图和概念数据模型的关系从设计到创建数据库的过程不是很熟悉,希望都能说一下 sql,求出选择同一课程的学生对即已知建有一个学生数据库,有很多小题的题目要完成, 英语翻译1.熟练掌握C/C++语言编程,能熟练应用相关工具Turbo C 2.0、Visual C++2.熟悉SQL语言,熟悉SQL Server2000数据库3.熟悉软件工程思想,了解网络原理知识并熟悉网络协议TCP/IP协议;4.对计算机硬件