[单选题]

In developing a hospital database, it is determined that on the average, each patient will have 6 treatments during a hospital stay.The average length of a stay is three days.The hospital has 1000 beds.There are on the average 800 patients occupying beds each day.The relationship between PATIENT and TREATMENT is 1: M.The relationship between PATIENT and BED is 1:1, conditional.If treatment record occurrences are archived as soon as a patient is discarded from the hospital, how many occurrences of the TREATMENT records will be stored in the TREATMENT database file on the average?

A.6,000

B.4,800

C.18,000

D.1,600

参考答案与解析:

相关试题

You are the database administrator for a

[单选题]You are the database administrator for a retail company. The company owns 270 stores. Every month, each store submits approximately 2,000 sales records, which are loaded into a SQL Server 2000 database at the corporate headquarters.A. Data Transforma

  • 查看答案
  • You are the database administrator for a

    [单选题]You are the database administrator for a financial services company. Employees enter data 24 hours a day into a SQL Server 2000 database. These employees report slower response times when new account information is gathered from branch offices and ad

  • 查看答案
  • You are a database administrator in the

    [单选题]You are a database administrator in the Los Angeles branch office of a specialty foods supplier. A mainframe. database at the headquarters contains all company data. Each branch office contains a SQL Server 2000 computer that imports regional data fr

  • 查看答案
  • You are the database administrator of a

    [单选题]You are the database administrator of a SQL Server 2000 computer. The server contains your company's Accounts database. Hundreds of users access the database each day.B.ecause you have had power interruptions in the past, you want to perfect the phy

  • 查看答案
  • In developing countries people are _____

    [单选题]Indevelopingcountriespeopleare________intoovercrowdedcitiesingreatnumbers.A.)breakingB)fillingC.)pouringD)hurrying

  • 查看答案
  • The complete database application can be

    [单选题]The complete database application can be divided into three major categories:data presentation.businesslogic,and data______.A.storageB.statisticsC.disposeD.analysis

  • 查看答案
  • The______scheme in a database system is

    [单选题]The______scheme in a database system is responsible for the detection of failures and for the restoration of the database to a state that existed before the occurrence of the failure.A.queryB.testC.checkD.RecoveryA.B.C.D.

  • 查看答案
  • You are a database developer for a conta

    [主观题]You are a database developer for a container manufacturing company. The containers produced by your company are a number of different sizes and shapes. The tables that store the container information are shown in the Size, Container, and Shape Tables

  • 查看答案
  • MMDB(Molecular Modeling Database)

    [名词解释] MMDB(Molecular Modeling Database)

  • 查看答案
  • Developing the project schedule is often

    [单选题]D.eveloping the project schedule is often an iterative process. It determines the planned start and finish dates for project activities and milestones. Schedule development can require the review and revision of duration estimates and resource estima

  • 查看答案