a. You have just been named Director of Data Administration of Happy Cruise Lines. Happy Cruise Lines maintains a central IS organization with several operational relational databases on several large servers at its headquarters. Each of its cruise ships has a medium-scale server on board with its own databases that help manage the running of the ship. Real-time transmissions are made via satellite between headquarters and the ships that keep both the headquarters and shipboard databases constantly up to date. You have been given a free hand to create a data administration department and supporting database administration departments for Happy Cruise Lines and its IS environment. Design your data and database administration functions. Include their responsibilities and explain how they will add value to the corporation.

b. Create a data dictionary TABLES table and an ATTRIBUTES table and enter data in them for Happy Cruise Lines’ database, shown in Minicase 5.1. Your answer should be based on the format shown in Figure 10.6. Use your judgment as to attribute type values, length values, etc.

c. Create a relationships table for this tables and attributes data, using the format in Figure 10.7. 

Transcribed Image Text:

(a) TABLES table Table Table Name Disk Number Length Salesperson 500 А23 Customer 6,400 А23 Customer Employee 127,000 А23 Product 83,000 A47 Sales 273,000 A47 Office 600 A47 (b) ATTRIBUTES table. Attribute Name Attribute Length Attribute Туре Salesperson Number Numeric Salesperson Name Alphabetic 20 Commission Percentage Numeric Year of Hire Numeric 4 Customer Number Numeric 4 Customer Name Alphabetic 20 FIGURE 10.6 HQ City Alphabetic 15 Two data dictionary tables 3. (a) TABLES table Table Table Name Disk Number Length Salesperson 500 А23 Customer 6,400 А23 Customer Employee 127,000 А23 Product 83,000 A47 Sales 273,000 A47 Office 600 A47 (b) ATTRIBUTES table. Attribute Name Attribute Length Attribute Туре Salesperson Number Numeric Salesperson Name Alphabetic 20 Commission Percentage Numeric Year of Hire Numeric 4 Customer Number Numeric 4 Customer Name Alphabetic 20 FIGURE 10.6 HQ City Alphabetic 15 Two data dictionary tables 3.

Answer rating: 100% (QA)

Table Name TABLES create table TABLESTableName varchar20 TableLength varchar15 DiskNumber varchar5You have made changes to the database You have made ... View the full answer