Part 3: Questions and Answers
1.Consider the following relational schema:
student (student no, _rst name, last name)
book (isbn, title, authors, publisher, year)
loan (student no, isbn, checkout date, duration)
Use SQL to write the following queries:
A. Create the table for the book table appropriate domain and required contraints.
B. Change the data type of the checkout date attribute of the loan table to date.
C. Add a constraint into the loan table to make sure the loan duration is no more than 180 days.
D. Grant Arvil and Amy select and update authrorization on the book table.
2.What are 6 basic operators of relational algebra?
3.Explain how natural-join operation can be accomplished by basic relational algebra operations?
4.Explain how the division operation can be accomplished by basic relational algebra operations?
5.The database of a research center contains the following three tables about employees,projects, and the time spent by the employees on the projects. Employee(ssn: int, name: string, jobTitle: string)
Project(pid: int, name: string, sponsor: string, startYear: int, endYear: int) WorkedOn(ssn: int, pid: int, year: int, month: int, noHours: int).
The table Employee lists all the employees of the centre. The table Project lists all the projects of the centre with their sponsor and the start and end year of the project. The table WorkedOn records how many hours the employees have spent on which project in which month. For each table, the attributes that make up the primary key are underlined.
Express each of the following queries in relational algebra.
A. Return the names of the projects that were active in 2008.
B. Return the names of those programmers who in some month spent more than 60 hours on a project sponsored by the EU.
C.Return the names of those programmers who never worked on a project sponsored by the EU.
6.Consider the relational schema of Question 5. Write SQL queries over this schema that answer the following questions.
A. How many projects that were active in 2008 were sponsored by the EU?
B. For each project, year, and month, how many hours of work have been spent? (Return only data for a project, year and month if some time has been spent.)
C. How many programmers are there who have experience in working on a project sponsored by the EU? (Note that a programmer who worked on two or more projects should be counted only once.)
D. Return the names of the programmers who worked on no more than two projects sponsored by the EU. (Note that this includes the programmers who never worked on any project sponsored by the EU.)
E. Which programmer(s) spent the maximal total number of hours on EU projects
among all programmers working on EU projects?
7.Consider the following relation that keeps track of the bookings in a hotel: Booking(guestID, guestName, creditCard, roomNo, roomCat, from, to).
Suppose the following functional dependencies hold on the relation:
guestID → guestName, creditCard
roomNo → roomCat
roomNo, from → guestID, to
roomNo, to → guestID, from.
A. Decompose the relation in smaller relations such that
– each of the smaller relations is in BNCF with respect to the projection of the original dependencies;
– the decomposition is a lossless join decomposition.
B.Is your decomposition dependency preserving? If your answer is “yes”, argue why. If y our answer is “no”, show which dependencies have been lost.
8.Draw an ER diagram that captures all the following information:
_ Patients are identified by an SSN, and their names, addresses and ages must be recorded.
_ Doctors are identified by an SSN. For each doctor, the name, specialty and years of experience must be recorded.
_ Each pharmacy has a name, address and phone number. A pharmacy must have a manager.
_ A pharmacist is identified by an SSN, he/she can only work for one pharmacy. For each
pharmacist, the name, qualification must be recorded.
_ For each drug, the trade name and formula must be recorded.
_ Every patient has a primary physician. Every doctor has at least one patient.
_ Each pharmacy sells several drugs, and has a price for each. A drug could be sold at several pharmacies, and the price could vary from one pharmacy to another.
_ Doctors prescribe drugs for patients. A doctor could prescribe one or more drugs for several patients, and a patient could obtain prescriptions from several doctors. Each prescription has a date and quantity associated with it.
9.Convert the following E/R design (for a simple banking application) into a relational design. Give the relational design as a relational diagram with arrows to indicate the foreign key relationships. Underline all attributes that correspond to primary keys.
10.Consider the following employee database, where the primary keys are underlined.
Employee(ename:string, street:string, city:string);
Works(employee:string, company:string, salary:real);
Company(cname:string, city:string);
Manages(employee:string, manager-name:string)
Give a single SQL statement for each of the following queries:
A. Find the names, street addresses, and cities of residence of all employees who work for “First Bank Corporation" and earn more than $40,000.
B. Find the names of all employees in the database who live in the same cities as the companies for which they work.
C. Give all managers of \First Bank Corporation" a 10 percent salary raise.
D. Find the names of all employees in the database who earn more than any employee of “Small Bank Corporation".
E. Assume that the companies may be located in several cities. Find the names of all companies located in every city in which \Small Bank Corporation" is located.
F. Find the name of the company that has the most employees.
G. Find those companies whose employees earn a higher salary, on average, than the average salary at “First Bank Corporation", display those companies' names in ascending order.
11.Consider the following (simplified) relational schema for university study: Student(id:integer, family:string, given:string, degree:string, enrolled:date)
Course(id:integer, code:string, session:string, title:string, syllabus:string) Enrolment(student:integer, course:string , mark:real, grade:string)
A.For each of the following SQL queries, write an efficient relational algebra
expression that might be used to implement the query. To make the expressions clearer, you may use as many named intermediate temporary relations as you wish. Correct, but grossly inefficient, relational algebra expressions will be awarded only half marks.
A. select given,family from Student
B. select * from Enrolment where student=2233456
C. select given,family,course
from Enrolment, Student
where Enrolment.student = Student.id
D. select e.code, e.session, c.title, e.mark, e.grade
from Enrolment e, Course c, Student s
where e.course = c.id and e.student = s.id and s.id = 2234567
12.Consider the following E/R diagram, modeling data about patients in a hospital:
A. Perform a conversion of the E/R diagram into relation schemas. You should eliminate relations that are not necessary (e.g., by combining relations).
13.Given the interleaved schedules:
Schedule 1
Schedule 3
A.Which of the following schedules are serializable? Give a serial schedule or identify possible anomalies.
B.Draw the precedence graph for all three schedules and check whether they are conflict-serializable or not.
C.Apply strict 2PL to the non-conflict-serializable schedules
D.In one of the schedules a deadlock emerges – draw the waits-for-graph for this schedule after all transactions are captured in the deadlock situation.
(Use X(.) to denote exclusive locks and S(.) to denote shared locks!)
14.Consider a relational schema ABCDEFGHIJ, which contains the following FDs: AB→C, D→E, AE→G, GD→H, IF→J.
A.Check whether or not the functional dependencies entail
ABD→GH
ABD→HJ
ABC→G
GD→HE
B.Let A denote a key for the aforementioned relation. Derive a lossless join,
dependency preserving decomposition in 3NF!
15.What do the ACID properties stand for? Give a brief description of the four characteristics.
16.What are the serial schedule, equivalent schedules and serializable schedule?
17.Let R and S are two relations shown as below:
A. ∏A,B+C→ X(R)
B. ∏B,C(R) -∏B,C(S)
C. B?B,sum
D.(S)
?B,maxD.(R S)
D.
18.Consider the following relational schema for movie DVD rental store: customer (customer id, first name, last name)
DVD (dvd id, title, genre, director, released year)
borrow (customer id, dvd id, checkout date, duration)
Use SQL to write the following queries:
A. Create 3 tables for the above schema with appropriate domain and required contraints.
B. Change the data type of the checkout date attribute of the borrow table to date.
19.Consider the following gradebook relational schema describing the data for a grade book of a particular instructor
catalog(cno, ctitle)
students(sid, fname, lname, minit)
courses(term, secno, cno, score)
enrolls(sid, term, secno)
Use relation algebra and SQL to write the following queries:
A. Retrieve the names of students enrolled in the 'Database' class in the term of Fall 2009.
B. Retrieve the names of students who have enrolled in CS226 or CS227.
C. Retrieve the names of students who have not enrolled in any class.
D. Retrieve the titles of courses whose average score of the whole class is more than
80.
20.Consider a company database with the following relation schemas where primary keys are underlined:
employee (first name, last name, id no, birthday, gender, salary, supervisor id no, department no)
department (department name, department no, manager id no)
department locations (department no, department location)
project (project name, project no, project location, department no)
works on (id no, project no, hours)
Use relation algebra and SQL to write the following queries:
A. Retrieve the names of all employees in the 'Research' department who work more than 10 hours per week on the 'ProductX' project.
B. Find the names of employees who are directly supervised by 'Avril Lavigne'.
C. Retrieve the names of employees who work on every project.
D. Retrieve the names of all employees who work on at least one project located in Houston but whose department has no location in Houston.
E. For each department, retrieve the department name, number of employees in that department, and the average salary of employees working in that department.
F. For each department whose average employee salary is more than $50000, retrieve the department name and
the number of employees working for that department.
G. Remove employees whose salary is more than $100000.
H. Increase the pay of all employees in the 'Research' department by 5%
21.Consider the following bank schema.
account (account id, branch name, balance)
borrower (customer id, loan number)
branch (branch id, branch name, branch city, assets)
customer (customer id, customer name, customer street, customer city)
depositor (customer id, account number)
loan (loan number, branch id, amount)
Write SQL commands for the following query:
A. Retrieve all different branch names.
B. Retrieve all loan number that falls between 1000000 and 2000000.
C. Retrieve all customer names in the ’East Gate’ branch.
D. Retrieve the branch name and number of accounts for each branch.
22.Consider the following order table.
where the keys are underlined.
A. Normalize the above table to the 3 NF and draw the relational schema diagram and indicate the primary keys and the referential constraints.
B. Based on the above schema diagram draw the ER diagram.
23. A student relation has 4 attributes: student id, name, email, and phone no. No two customers have the same student id and email.
A. List keys, superkeys, and primary key for the student relation.
B. Explain the reason of choosing the primary key.
24. Consider the following electronic store database:
Use SQL to answer the following questions.
A. Create the product table with the required constraints.
B. Add a constraint of price > 0 in the product table.
C. Insert ('P2348', 'Personal Computer', 1200) into the product table.
D. Find the all customers who have ordered a WII.
E. Change the price of 'WII' from 8000 to 7500.
F. Remove all orders that 'Lady Gaga" has put.
25. Consider The database of a online game company has three relations: player, play, and game for storing information about players who plays which game. The database schema of the game company is shown as follows:
player (member no, name, level, phone, email)
play (member no, game id, date, time)
game (game id, title, type)
Please draw the ER diagram.
26. Consider a HollyWood Enterprise that requires modeling information about the different type of people
A.involved in the movie production.
B._ Each person should have person ID, name, phone, gender, and address.
C._ There are two main groups of persons: Movie professionals and celebrity. Each
movie professionals work on some
https://www.doczj.com/doc/5912405296.html,pany.
E._ A movie professionals can be either a director or a agent. Each director has her
or his popularity and can direct a
F.number of movies. Each agent has the agent fee.
G. A celebrity can be a movie star, a model, or both. Each movie star has her or his
movie style and play in some
H.movies. Each model has her or his preferences.
I._ Each movie has the information about the title, released date, and language.
J.Draw a EER diagram for the above HollyWood Enterprise.
K.The owner of several apartment buildings is interested in a database to manage his L.business.
M.
N.
etc.
O.eriod of lease. P.Tenant information is his/her name and phone number.
Q.
salary.
R.
spaces.
Design an E-R diagram for the above. State any additional assumptions.
Convert the above E-R diagram (Q.1) to relational model and write the SQL
commands to create the tables for both the entities as well as relationships.
27.The following questions are based on a Sporting Goods database described below:
customer (id: int, name: string, city: string, country: string, rating: string,
sales_rep_id: int )
dept(id: int, name: string, region_id: string)
sales_rep(id: int, last_name: string, first_name: string, dept_id: int, salary: int) order(id: int, customer_id: int, date_ordered: date, total: int)
Write SQL queries for each of the following sub-questions.
A. Display the name, city, country and rating of all customers whose number of
orders exceeds the “average” number of orders for a cu stomer.
B. Display the name of all the departments that have at least one employee.
C. Display the first name and last name of all sales representatives who do not
have customers.
D. Find the countries in which there are no sales representatives. If required, make
any assumptions and state them.
28.Consider the relation R, which has attributes that hold schedules of courses and sections at a university; R = {CourseNo, SecNo, OfferingDept, CreditHours, CourseLevel, InstructorSSN, Semester, Year, Days_Hours, RoomNo, NoOfStudents}. Suppose that the following functional dependencies hold on R:
{CourseNo} →{OfferingDept, CreditHours, CourseLevel}
{CourseNo, SecNo, Semester, Year} →{Days_Hours, RoomNo,
NoOfStudents, InstructorSSN}
{RoomNo, Days_Hours, Semester, Year} →{InstructorSSN, CourseNo, SecNo}
A.Try to determine which sets of attributes form keys of R. How would you
normalize this relation?
29.Consider the relational database schema and write the SQL statements according to the this model.
Part(PartNo, PartName, ProjNo Price, Weight)
Project(ProjNo, ProjName, Location, departNo)
Emp(Ssn, Name, Surname, departNo, Addres, salary)
Work(ssn, ProjNo, Hour)
A.Listing the workers info, according to the PartNo=24 that is used in the
one project.
B.Listing the project names and locations, according to the employees
address includes “Bahcesehir”.
C.Alter the emp table and add a new column which is corresponding the
emp’s birth date.
D.List the emp info, according to the his salaries greater than avarage salary
of the emp table.
30.Branch(branch-name, branch-city, assets)
Account(account-number, branch-name,balance)
Depositer(customer-name, account-number)
Customer(customer-name, customer-street, customer-city)
Loan(loan-number, branch-name, amount)
Borrower(customer-name, loan-number)
Database schema is given above.
A.Find all customers who have both an account and a loan in the bank.
B.Find all customers who have a loan at the bank but do not have an account
at the bank.
C.Find all customers who have both an account and a loan at the Perryridge
branch.
D.Find all branches that have greater assets than some branches located in
Brooklyn.
E.Find all loan numbers which appear in the loan relation with null values
for amount.
31.You have been asked to design a database for the university administration, which records the following information:
1. All students necessarily have a unique student ID, a name, and a university email address. Each student is also either an undergraduate or a graduate student.
2. Each graduate student has an advisor.
3. Each undergraduate student has a major.
4. Students take courses. A student may take one course, multiple courses, or no courses.
5. Each course has a course number, course name, and days of the week the course is scheduled.
6. Each course has exactly one head TA, who is a graduate student.
7. Every head TA has an office where he or she holds office hours.
A. Draw an ER diagram for this application. Be sure to mark the multiplicity of each relationship of the diagram. Decide the key attributes and identify them on the diagram. Please state all assumptions you make in your answers.
B. Translate your ER diagram into a relational schema. Select approaches that yield the fewest number of relations; merge relations where appropriate. Specify the key of each relation in your schema.
32.Consider a relation R with five attributes A, B, C, D, and E. The following dependencies are given:
AB→ C, BC → D, CD → E, DE → A.
A. List all keys for R. Do not list superkeys that are not a key.
B. Is R in 3NF? Briefly explain why.
C. Is R in BCNF? If yes, please explain why. Otherwise, decompose R into relations that are in BCNF.
33.The following questions refer to the database schema below: Product(pid, price, color), Order(cid, pid, quantity), Customer(cid, name, age).
A. Write a query, in relational algebra, to return the names of customers who order at least one product with color “Red.”
B. Write an SQL query, to return the total quantity of products ordered by customers with age greater than 70.
C. Write an SQL query, to return the pid(s) of the most ordered product(s) (i.e. the product(s) with the highest total ordered quantities).
34.Consider “drinker” database with the following relations.
Drinker(drinkerName, street, age)
Bar(barName, owner, street)
Frequent(drinkerName, barName)
We ask you to write queries. Please write simple and non-redundant queries – Note that we will really check if your answers are unnecessarily complex.
A. In relational algebra, write a query to return the bars that Sally frequents.
B. In relational algebra, write a query to return each drinker who frequents only bars on the same street that he lives.
C. In SQL, write a query to return the bars whose frequent drinkers are “young”– in particular, with average age below 37.
35.Consider the following relational schema:
Account(accountNumber, branchName, balance)
Branch(branchName, street, city, assets)
Customer(customerSSN, street, city)
Deposit(customerSSN, accountNumber,Amount)
A. List all the attributes (in the four tables) that are foreign keys and indicate what attributes they are referencing.
B. Define a view BigBranch that gives for each branch its branchName, city, and assets. The branch should have more than 50 accounts and the total balance of all accounts is greater than $1,000,000.
C. Suppose we want to check that, for each branch, the total balance of all accounts is less than or equal to the assets of the branch. Complete the following SQL statement, by specifying _condition_. Note, by definition, such an “assertion” statement will enforce the _condition_ to hold true at all times.
CREATE ASSERTION BalanceCheck CHECK _condition_
36.Convert the following unnormalized tables into First Normal Form (1NF) relations :
(a)R(A, B, {C, D})
(b)R(A, B, {C, D, {E, F}})
37.Convert ER diagrams A and B below into relations.
一、 分） 2. 3. 5. 7. 9. B、is worth looking C、B、close C、B、thousands of C、B、in trouble C、 姓名学号班级 出题审阅批准装订线
A、came B、comes C、will come （） A、cried （） early. A、look at pictures （） A、is （） A、to stay （） A、 important as （）11.Please show your card _____ me. A、to B、for C、with （）12.Don’t forget _____ your kite when you go for a picnic. B、to bring C、take B、tastes C、looks B、to drink C、eat 、and C、after B、something different C、 （）17. Taiwan is _____ island in China. A、large B、the largest C、much
larger （ ）18. The first and most important thing to do on the first day of the A 、New Year （ ）A 、and more （ ）20. 29th A 、on B 、in C 、for 三、完形填空。（共10分） The man in the photo is my father. He?? _21_? a blue jacket and black pants. He is a(n)? _22_? .He works for a newspaper. Mother and I can?? _23?_ see him on the 28th of every month,?? _24_?? he . He’s even （甚至） C. writes D. takes C. reporter D. teacher only C. often D. C. because D. so zoos C. streets D. C. hungry D. C. his D. my they’re C. he’s D. C. tells D. says C. is D. ( 根据短文的意思，判断正误，对的
目录 摘要............................................................................................................................. I 第1章绪论 (1) 1.1系统开发背景 (1) 1.2国内外的研究现状 (1) 1.3系统解决的主要问题 (3) 1.4本文的主要工作 (3) 1.5本文的组织结构 (3) 第2章需求分析 (5) 2.1系统概述 (5) 2.1.1总体业务描述 (5) 2.1.2系统的目标和解决的问题 (5) 2.1.3系统的开发模式 (7) 2.2系统需求问题描述 (9) 2.2.1功能性需求 (9) 2.3.2系统非功能性需求 (12) 第3章系统构架设计 (14) 3.1构架的目标和约束 (14) 3.2构架设计 (15) 3.2.1系统总体架构 (15) 3.2.2系统功能构架 (16) 3.2.3系统技术构架 (17) 3.2.4系统安全构架 (18) 第4章系统详细设计 (20) 4.1 系统建模 (20) 4.2 系统数据库设计 (24) 4.2.1生成数据库表 (24) 4.2.2数据分析 (32) 4.2.3数据库管理技术 (34) 第5章计算机排课系统的实现 (35) 5.1系统总体实现 (35) 5.1.1数据录入模块的设计与实现 (38) 5.1.2报表模块的设计与实现 (43) 5.1.3用户管理模块的设计与实现 (45) 5.2教学计划的关键实现 (48) 5.2.1算法描述 (49) 5.2.2教学计划算法过程 (49) 5.3排课算法的关键实现 (51) 第6章总结与展望 (66) i
英语语法专练 第一部分冠词 there ____“s”in the end of the word D. / 2.Mr. Wang is ____honest man. D. / is ____university student. D. / 4. ____ book is very useful. I bought it from____unknown little town. , a , a , the , an in ___Grade three is ____tallest in our school. , the, the , a, a , ×, the , ×, a moves around____earth,and they both are smaller than ____sun. , an, a , the, the C.×, ×, × , the, the 7. She was playing ____piano then. B./ should care for ____old. , a , the , a , the city lies on ____Yangtzi River. C./ doesn’t have ____lunch at home.
C./ 第二部分名词 there ____on that plate There are ____under that tree. chicken chicken chickens chickens need two ____to repair the table. of woods of wood of wood of woods know ____doesn’t runl so fast as light（光）. sound sound are sixty ____in our school. teacher teachers teachers teacher Smith is a friend of_____. ’s mother’s ’s mother ’s of Mary mother’s 第三部分数词 always wanted to have ___of books and he has recently bought four ____. ,hundred ,hundred ,hundreds ,hundreds People’s Republic of China was founded ____,1949. October 1 October 1st October 1st 1 3friday is the ____day of the week.
专科英语复习资料 一. 单项填空从A、B、C、D四个选项中，选出可以填入空白处的最佳选项. 1. I have ___B____ question to ask you. A.\ B.a C. the 2. I didn’t think maths __ A____ difficult for Tom. A. is B. are C. was D. were 3. _B___do you go to see your Granny? Four times a month. A. How long B. How often C. How soon D. How many 4. I think foreign languages are ___C _____ than science. A. interesting B. the interesting C. more interesting D. most interesting 5. Her parents are __A_____ professors. A. both B. all C. any D. some 6. I didn’t know __A __to do with it. A. What B. Which C. Why D. When 7. ___A___ expensive the sweater is ! A. How B. What C. How a D. What a 8. ----__B_ have been in this city? ---- For about two weeks A. How often B. How long C. How soon D. What time 9. —Is John coming by train? —He should, but he ____d___ not. He likes driving his car. A. must B. can C. need D. may 10. ----Whose advice do you think I should take? -----.___C____. A. You speak B. That's it C. It's up to you D. You do it 11. Before radio and TV, music could only be heard _D_, that is, you had to go to places where musicians give performances. A. live B. alive C. living D. lively 12. My study of maths has _D___ much of my time, but it has given me a great deal of enjoyment. A. taken off B. taken down C. taken away D. taken up 13. China has had _____A_____ long tradition of celebrating Mid - Autumn Festival throughout ____nation. A. a; the B. a; a C. the; a D. the; X 14. Jack is still on summer ___B__ while Sophie is feeling chill up in Vancouver. A. rest B. vocation C. travel D. way 15. I don’t like talking on __B__telephone; I prefer writing ______letters. A. a; the B. the; 不填 C. the; the D. a; 不填 16. ---- Will you go skiing with me this winter vacation? ---- It _____C_____. A. all depend B. all depends C. is all depended D. is all depending 17. This is Ted’s photo. We miss him a lot. He _C__trying to save a child in the earthquake. A. killed B. is killed C. was killed D. was killing 18. ----I think it’s g oing to be a big problem. ----Yes, it could be. ----I wonder __A__we can do about it. A. if B. how C. what D. that 19.----I hear you’ve got a set of valuable Australian coins -----_B___I have a look? ------Yes, certainly. A. Do B. May C. Shall D. Should 20 ----He was nearly drowned once. ----When was__A__? ----_____was in 1998 when he was in middle school. A. that; It B. this; This C. this; It D. that; This 21. Unless they are programmed by humans, computers are nothing more than big pieces of metal. But once __A_ what to do, they show extraordinary power in carrying it out. A. taught B. teaches C. teaching D. to teach 22. ----How are the team playing? ----They’re playing well, but one of then __A___hurt. A. got B. gets C. are D. were 23. ----You’re always working. Come on,let’s go shopping. ----__A__ you ever want to do is going shopping. A. Anything B. Something C. All D. That 24.It will be quite a long time __A___ she is back again, so don't be too cross with her. A. that B. since C. before D. until 25. ----Smoking is bad for your health. ---- Yes, I know. But I simply can’t__A___. A. give it up B. give it in C. give it out D. give it away 26. Two middle-aged passengers fell into the sea. __C__, neither of them could swim. A. In fact B. Luckily C. Unfortunately D. Naturally 27. The famous basketball star, __D___tried to make a comeback, attracted a lot of attention. A.where B. when C. which D. Who 28. Science is a little more difficult than English, but I ___B___ science to English. A. drop B. prefer C. enjoy D. like 29. Rose works as ___B___ as her brother. A. good B. well C. better D. best 30.Henry can't attend the meeting at present because he is preparing the speech at the party __A__ at Marie's house tomorrow. A . to be held B .hold C. to hold D. being held 31. “__A___ will he be back?”“In two weeks.” A. How soon B. How long C. How often D. How much 32. I won’t go swimming if it __C____ tomorrow. A. will rain B. rain C. rains D. won’t rain 33. It is generally considered unwise to give a child __B___ he or she wants. A. however B. whatever C. whichever D. whenever 34. With the rapid growth of population, the city __B___ in all directions in the past five years. A. spreads B. has spread C. spread D. had spread 35. I met the teacher in the street yesterday _D___ taught me English three years ago. A. which B. when C. where D. who 36.. ---- Why did you go back to the shop?
一、需求分析 需求分析是数据库设计的必要和首要设计阶段，将会影响以后数据库设计的延续和质量，需求分析方法也很多，最重要是形成有实用价值的实际性的数据字典和数据流图。在该排课系统的需求分析阶段，主要是通过询问和自己所掌握的关于该系统的数据联系方式和工作方式，形成了关于该系统的数据字典和数据流图。 1.1需求表述 1.1.1 基本功能描述 排课系统的数据库设计主要完成工作有： 1、数据库管理员对数据的录入和相关完整性条件约束的建立， 2、数据库相关的触发器与存储过程对数据库中数据的联系的 管理； 3、执行程序能够高效率地完成数据处理和调用； 4、能够通过DBMS建立一系列视图来更方便的操作数据库。1.1.2 开发技术描述 开发工具：Microsoft SQL Server 2005 SQL Server 2005 是microsoft 公司推出的数据库管理系统，该版本继承了SQL Server 2000 版本的优点，同时又比它增加了许多更先进的功能。具有使用方便可伸缩性好与相关软件集成程度高等优点，可跨越从运行Microsoft Windows 2000 电脑到运行Microsoft Windows XP 的大型多处理器的服务器等多种平台使用。本实验中最终将使用Microsoft SQL Server 2005数据库管理系统将我们设计的数据库实现。 1.2分析形成初步数据字典 数据字典(Data Dictionary，DD)是数据库设计需求分析阶段后通过科学的处理方法得到的该系统中各类数据描述的集合，也是进行详细数据收集和数据分析所获得的主要成果，它在数据库设计中占有恨重要的地位。 数据字典通常包括数据项、数据结构、数据流、数据存储和处理过程5个部
初中英语语法综合测试题 1. They want their daughter to go to university, and they also want her to get summer job. A. /; a B. the; a C. an; a D. a; the 2.—Would your younger brother go for a picnic this Sunday? —If I don’t go, . A. so does he B. so will he C. neither does he D. neither will he 3. —Are these books ? —No, they are not mine, they belong to . A. your, her B. yours, her C. you, hers D. yours, she 4. People went to the concert which was held in People’s Square the night of May day. A. Thousands of, in B. Thousand, on C. Many thousand, in D. Thousands of, on 5. The more you smile, the you will feel. A. happy B. happily C. more happily D. happier 6. I will send you an e-mail as soon as I in Canada. A. am arriving B. will arrive C. arrive D. arrived 7. Jack dislike the weather in Beijing in spring, because there is so much wind and sand. But now he it. A. is used to, used to B. used to, is used to C. was used to, is used to D. used to, uses to 8. There on the wall. They are very beautiful. A. are photos B. are photoes C. is a photo D. is photos 9. This kind of car made in Shanghai. A. is B. are C. were D. has 10. The of the cottage were covered with . A. roofs; leafs B. roofs; leaves C. roves; leafs D. roves; leaves 11. Something was wrong with car, but luckily they knew how to fix it. A. Jim’s and Tom’s B. Jim and Tom’s C. Jim’s and Tom D. Jim and Tom 12. There are four and two in the group.
JIANGXI AGRICULTURAL UNIVERSITY 本科课程实训 题目: 关于学生排课系统的数据库设计 学院: 软件学院 姓名: 肖力谢果 学号: 20101466 20101467 专业: 软件工程 班级: 软件1001 指导教师: 黄欣 2011年12月
引言: 由于当下大学学校班级及专业较多,我们学校的实用的帮助班级排课的一个系统也有迫切需求。基于用SQL Server设计的数库的排课系统也有很大的需要,在本实训作业中,将会针对该实际情况,对我校江西农业大学的学生上课排课系统的数据库进行设计。 该设计工作由双人合作的形式完成,对一个学期以来数据库系统概论的学习进行巩固与联系。该排课系统主要设计流程工作大概分为三个阶段:需求分析,概念结构设计,逻辑结构设计,也将设计的物理结构与数据库实施维护从略讲述,着重在需求分析上的收集数据形成实体及其联系的数据字典完成,在需求分析的基础上完成数据流图的基本设计;在概念结构设计上完成数据的抽象形成各子系统的E-R图,最后在解决冲突的分析下完成基本总实体-联系(E-R图);在逻辑结构设计阶段中完成数据的抽象及实体的形成,实体的规范分析及完整性约束,以及设计阶段的有关触发器的创建分析与实现……最后简要对数据库设计的步骤的物理设计与实施阶段简要概述。 课程设计为实验周两天完成,使用流行的SQL Server 2005数据库系统完成基本设计工作,通过数据库管理系统(DBMS)、T/SQL基本语句实现数据库表的创建,表的完整性约束,表的视图及触发器的创建,基本工作都按照实训题要求基本完成。
一、需求分析 需求分析就是数据库设计的必要与首要设计阶段,将会影响以后数据库设计的延续与质量,需求分析方法也很多,最重要就是形成有实用价值的实际性的数据字典与数据流图。在该排课系统的需求分析阶段,主要就是通过询问与自己所掌握的关于该系统的数据联系方式与工作方式,形成了关于该系统的数据字典与数据流图。 1.1 需求表述 1、1、1 基本功能描述 排课系统的数据库设计主要完成工作有: 1、数据库管理员对数据的录入与相关完整性条件约束的建立, 2、数据库相关的触发器与存储过程对数据库中数据的联系的管理; 3、执行程序能够高效率地完成数据处理与调用; 4、能够通过DBMS建立一系列视图来更方便的操作数据库。 1、1、2 开发技术描述 开发工具:Microsoft SQL Server 2005 SQL Server 2005 就是microsoft 公司推出的数据库管理系统,该版本继承了SQL Server 2000 版本的优点,同时又比它增加了许多更先进的功能。具有使用方便可伸缩性好与相关软件集成程度高等优点,可跨越从运行Microsoft Windows 2000 电脑到运行Microsoft Windows XP 的大型多处理器的服务器等多种平台使用。本实验中最终将使用Microsoft SQL Server 2005数据库管理系统将我们设计的数据库实现。 1.2 分析形成初步数据字典 数据字典(Data Dictionary,DD)就是数据库设计需求分析阶段后通过科学的处理方法得到的该系统中各类数据描述的集合,也就是进行详细数据收集与数据分析所获得的主要成果,它在数据库设计中占有恨重要的地位。 数据字典通常包括数据项、数据结构、数据流、数据存储与处理过程5个部分。其中数据项就是数据的最小组成单位,若干个数据项可以组成一个数据结构,以下将把分析收集的数据及其结构列出:
人学英语语法专项练习题及答案 一、时态 1. By the end of April Peter here for three mon ths. A. will have stayed B. will stay C. stays D. has stayed 2. rm awfully sorry, but I had no alter native. I simply what I did. A. ought to have done B. have to do C. had to do D. must do 3. We our breakfast when an old man came to the door. A. just have had B. have just had C. just had D . had just had 4. Ever si nee the family moved to the suburbs last year, they better health. A. could have enjoyed B. had enjo yed C. have bee n enjoying D. are enjo ying 5. I bought a new house last year, but I my old house yet, so at the mome nt I have two houses. A. did not sell B. have not sold C. had not sold D . do not sell 6. I decided to go to the library as soon as I A. finish what I did B. fin is hed what I did C. would finish what I was doi ng D. fini shed wha t I was doi ng 7. He whe n the bus came to a sudden stop. A. was almost hurt B. was hurt h imself C. was to hurt himself D. was hurti n g himself 8. I suppose that when 1 come back in ten years' time all those o ld houses dow n. A. will have bee n pulled B. will have pulled C. will be pulli ng D. will b e pulled 9. Bob's leg got hurt the Purple Mountains. A. while he is climbi ng up B. while we were climb ing up
82412--英语Ⅰ（专科）期末备考题库82412奥鹏期末考试题库合集 单选题： （1）Someone is at the door. _____must be Mr. Black. A.He. B.It. C.This. D.That. A 正确答案：A （2）The doctor listened carefully_____he might discover exactly what the patient neede## A.so as that. B.in case. C.providing. D.in order that. 正确答案：D （3）—Look! You have made the same mistake again! —Oh, not again! I am_____making such a mistake. A.never. B.regularly. C.almost. D.always.
正确答案：D （4）It may have been at St. Valentine_____John gave Jane a handbag. A.before. B.who. C.that. D.when. 正确答案：C （5）He _____ CDs every time he goes shopping. A.bought B.buy C.buys D.buying 正确答案：C （6）She received several_____letters this morning. A.official. B.office. C.unofficial. D.officer. 正确答案：A （7）I was paid last week, but I can’t remember the exact_____of money. A.number.
初中英语语法综合练习题 单项选择 1、The boy likes questions. A．ask B．answer C．to ask 2、We'll try there on time. % A．to get B．getting C．got 3、They hoped their mother soon. A．to see B．saw C．seeing 4、I'm glad you again. A．meet B．met C．to meet { 5、He often helps me my bike. A．mending B．to mend C．to mended 6、I heard Alice in the next door. ~ A．sings B．sang C．sing 7、The work is easy. Let him it by himself.
A．do B．to do C．doing 8、He saw Dick in and take a book away. A．came B．coming C．come 、 9、Does Jack want a writer A．be B．is C．to be 10、The boss had them from morning to night. A．worked B．working C．work 【 11、It's time home. A．to go B．went C．going 12、Tom is kind. He would like you. A．to help B．help C．helped 【 13、Don't forget your books to school. A．bring B．to bring C．brought
姓名： 学号： 专业： 层次： （答题不能超出密封装订线） 《英语一》试卷（A 卷） 考试时间： 120分钟 考试方式： （开卷/闭卷） 一、单项选择（每题2分，共20分) 1. I had neither a raincoat nor an umbrella. _____ I gotwet through. A. It is the reason B. That is why C. There is why D. It is how 2. Whenever my uncle came to see me, he____ bring me some candy. A. will B. would C. was D. should 3. She is fond of____ stamps. A. collect B. to collect C. collecting D. collection 4. ____you have any questions or needs, please contact the manager after 5:00 p.m. on weekends. A. Because B. Where C. If D. Though 5. This problem is____ his ability and I do not think he can solve it. A. to B. in C. beyond D. under 6、 Jack would rather spend time complaining than____ the problem by himself. A. solve B. solved C. solves D. solve 7. It worried her a bit____ her hair was turning gray. A. while B. that C. if D. for 8. Can you make sure____ the gold ring? A. where Alice had put B. where had Alice put C. where Alice has put D. where has Alice put 9. ____the day went on, the weather got worse. A. With B. Since C. While D. As 10. I t is required that anyone applying for a driver license____ a set of tests. A. take B. takes C. took D. will take 二、选词填空（每题1.5分，共10分） 1. I fully agree to the arrangement and it. 2. We make mistakes when we do things in a hurry. 3. In spite of difficulties, they decided to with the work. 4. Try to how many steps it will take to get to a close object. 5. My grandmother was becoming more and more sad and frail as the years . 三、阅读理解（每题2分，共10分) It is so easy to earn rewards! A wide range of partners whether you go To make traveling even easier, Air France offers you Frequency Plus(常旅客里程奖励计划)through an extensive network of our partners. Together, they give you endless opportunities to earn Miles and a wide choice of Rewards, from airline tickets, hotel room -nights, car rentals and more. Partners in China If you are a Frequency Plus member registered in china, you have even more choices with rewards from our local partners. For more information, please contact your local Air France office. First rewards start as low as 20,000 Miles! Your Temporary Card Start earning the Miles that will make you get your first Reward, now a) Show your Temporacy Card and simply give your Card number when making a reservation and at check -in for your flight. In this way, you will begin to earn Miles even before receiving your Permanent Card. b) Fill in and return your personal membership(会员) application today. Your application must be received within 3 weeks of your flight. Remember, you will enjoy an extra 3,000 Bonus Miles(额外奖励历程) for your fist trip with Air France within 6 months of joining. Fly today and earn Rewards sooner! 1. Air France carries out its Frequency Plus_____. A. through its reduced ticket prices B. through its extensive network of partners C. by providing convenient flight schedules D. by offering excellent services on
详细设计说明书 目录 1引言 (1) 1.1编写目的 (1) 1.2定义 (2) 1.2.1专业术语 (2) 1.2.2缩写 (2) 1.3参考资料 (3) 2.总体设计 (3) 2.1 任务目标 (3) 3.程序描述 (4) 3.1系统接受信息模块 (4) 1.ClassInfoExam过程 (4) 2.IErrorHandle过程 (5) 3.2系统输出信息模块 (5) 1.CDataRecPrc过程 (5) 2.ClassOutpt过程 (5) 3.3数据库设计 (6) 1引言 1.1编写目的 在前一阶段（概要设计说明书）中，已解决了实现该系统需求的程序模块设计问题，包括如何把该系统划分成若干个模块、决定各个模
块之间的接口、模块之间传递的信息，以及数据结构、模块结构的设计等。在以下的详细设计报告中将对在本阶段中对系统所做的所有详细设计进行说明。 本文档为排课系统设计、实现、测试、以及验收提供重要的依据，也为评价系统功能和性能提供依据，本文档可供用户、项目管理人员、系统分析员、程序设计人员、以及系统测试人员阅读和参考。 项目名称：排课系统 任务提出者：各大高校 开发者：江西农业大学软件学院 用户：学校教务处，学生，老师 1.2定义 1.2.1专业术语 SQL SERVER: 系统服务器所使用的数据库管理系统（DBMS）。 SQL: 一种用于访问查询数据库的语言 事务流：数据进入模块后可能有多种路径进行处理。 主键：数据库表中的关键域。值互不相同。 外部主键：数据库表中与其他表的主键关联的域。 ROLLBACK: 数据库的错误恢复机制。 1.2.2缩写 系统：若未特别指出，统指本机票预定系统。 SQL: Structured Query Language（结构化查询语言）。 ATM: Asynchronous Transfer Mode (异步传输模式)
成教专科英语模拟试卷（D） Part I Vocabulary and Structure Section A Directions:There are 10 incomplete statements here. You are required to complete each statement by choosing the appropriate answer from the 4 choices marked A, B, C, and D. You should mark the corresponding letter with a single line through the center. 1.She is much _________ his sister. A. tall than B. tallest of C. taller than D. taller of 2. You should _________ what you do. A. be responsible for B. responsible with C. be response to D. are responsible of 3. The summer vacation is round the corner. They decided to ___the holiday and study French. A. made a good use of B. make good use of C. makes use for D. made use for 4. The desk ________ a piece of white cloth. A. covers B. is covering on C. is covered with D. be covered 5. When he was in the middle school, Mr. Wang ____ a room ___ his foreign friend, Tom. A. rented …with B. shared … with C. lived … with D. stayed …with 6. I often think of the years _____ I lived in the countryside. A. where B. when C. who D. which 7. In her class, Mary is the only girl _________ is under the age of 18. A. that B. which C. whose D. whom 8. ________ the businessmen advertise are their products. A. Whether B. What C. When D. Whoever 9. If it ____ fine tomorrow, we will go the park. A. be B. was C. were D. is 10. The old man keeps swimming in winter, _____ he is over 70. A. in case B. though C. as soon as D. as long as Section B Directions: There are also 10 incomplete statements here. You should fill in each blank with the proper form of the word given in the brackets. Write the word or words in the corresponding space. 11. You (require) _____ to be present at 7 p.m.. 12. This (decide) _____ was made according to the specific circumstances. 13. When you have made your (choose) _____, telephone us. 14. She got a job as a sales (assist) _____selling handbags. 15. She has been (success) _____in keeping her privacy. 16. Thank you for the (invite)_____. We'd be very happy to come. 17. I have met Mr. White on several (occasion) _____. 18. He asked his teacher to write a letter of (recommend) _____. 19. The (fly) _____will take three hours. 20. The travelers were (die) _____ tired after the long journey.