100%(10)10 out of 10 people found this document helpful
This preview shows page 3 - 6 out of 8 pages.
Scenario Manager in Excel allows you to create predefined scenarios where each scenario may differ in the values of some inputsYou can generate outputs corresponding to each predefined scenarioFor decision making, these scenarios could be “best case” alternative, “worst case” alternative, “typical”alternative*Case 6 (Lab)DCP is an event planning company that only carries large national accountsThe company coordinates events including annual sales meetings and large conventionsAttendance at these events is 1000 to 15000 peopleYou are assuming the role of an event coordinator working for DCPYou have been assigned to develop and manage a database (in Microsoft Access) that stores data about DCP’s clients and the various events that the clients have scheduled with DCPIn addition you should be able to generate queries and reports based on the information needs of the top executives of DCPRelationship Diagram:Based on the ERD, Which of these fields cannot have an empty (NULL) value?Info Systems Notes for the Final (power point from teacher with notes from student and expansion on book)* = Not on the Mid Term
A.TotalCost in the EventSchedule TableB.EventName in the EventSchedule TableC.ClientID in the ClientInformation TableD.ClientName in the ClientInformation Table Based on the erd which of these is leastlikely to be true?Creating Table involves:Defining the fields/columns and their data types. Data type of a field is the type of data (e.g., text, number, date) that will stored in the field. The database (DBMS) will enforce the data type of the field when the data is added.Specifying the primary key. The database will enforce unique (and not null) values for primary key.As needed, specifying field properties such as field size, format, input mask, and validation rules that enforce more specific requirements for data entry and storageWhile tables may be created in a “spreadsheet-like” view, the design view provides a more professional(consistent and efficient) interface for creating tables.You may add data:Directly into the tableThrough an input formReferential Integrity: The foreign key (e.g., ClientID in EventSchedule Table) can be either null (empty) or one of the primary key values in the parent table (e.g., ClientID in ClientInformation table)Info Systems Notes for the Final (power point from teacher with notes from student and expansion on book)* = Not on the Mid Term
Cascade Update Related Fields: If a primary key value in the parent table (e.g., ClientInformation table)is changed, corresponding changes are made to the foreign key values in the related table (e.g., ClientID in EventSchedule Table) Cascade Delete Related Fields: If a record in the parent table (e.g., ClientInformation table) is deleted, all records in the related table (e.g., EventSchedule table) that reference the primary key of the deleted parent table record are also deleted