Exercise 1-2 A small library keeps a roster of who will be at the desk each day. They have a database table as shown in Figure 1-8. week_start Mon - Tue - Wed - Thur - Fri 17/10/2011 Jane Sue George Sue Jane 24/10/2011 Jane Sue Linda Sue Lee 31/10/2011 Sue Sue Lee | George George Figure 1-8. An initial database table to record roster duties What problems can you foresee in making good use of this information? Suggest some better ways that this information could be stored.

Exercise 1-2 A small library keeps a roster of who will be at the desk each day. They have a database table as shown in Figure 1-8. week_start Mon - Tue - Wed - Thur - Fri 17/10/2011 Jane Sue George Sue Jane 24/10/2011 Jane Sue Linda Sue Lee 31/10/2011 Sue Sue Lee | George George Figure 1-8. An initial database table to record roster duties What problems can you foresee in making good use of this information? Suggest some better ways that this information could be stored.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Dr. Jones, knowing that you are an intuitive database design student, has come to you with a possible database solution for his medical practice. He is interested in storing data related to his patients and the medications that they take. He specifically would like to keep track of the drug names, the drug price, the dosage each patient takes, and the dates that the medications were prescribed. He needs to be able to pull patient data quickly to make sure that each patient is taking the least medication to help their illness. Create business rules that might go with this scenario. Keep in mind that nouns (subjects) will become entities and their characteristics attributes. Verbs will translate into the relationships between entities. Create the ER diagram using Visio that would go with this scenario. Be sure to include entities, attributes, keys, and relationships using the crow’s feet notation
Indicate the changes (using the shorthand representation) that you would need to make to the original KimTay Pet Supplies database design to support the following requirements. There is no relationship between customers and sales reps. When a customer places an order, any sales rep can process the order and create the invoice. On the invoice, you need to identify both the customer placing the order and the sales rep responsible for the invoice. Draw an E-R diagram for the new design.
Data standardization usually focuses on fixing _ of data while data cleaning usually focuses on fixing _ of data. A- The entity; data dictionary B- The attribute; the entity C- The entity; the attribute D- Data dictionary; the entity
Draw logical ER diagram
E-R diagrams or DBDL may show database structure. Why do you prefer this method?
T. Relational Model Instructions This assignment will show that you understand how columns should be separated between tables in a properly structured relational database. Your objective: Imagine you need to design a database that tracks members, type of membership, and exercise routines for each member. • Build a relational database model with multiple tables • Use your imagination and feel free to create the tables with as many columns as you would like. • Highest points will be awarded for completeness AND correctness. Submit as an Excel workbook or image.
Question A city college would like to maintain their academic information in a MySql database system. The following are the interested information: Courses: Catalog # (M170 for instance) Credit Hours; Name of the Course (Database Design Fundamentals for instance) Course Descriptions Prerequisite Components (Lecture, or Laboratory for instance) Classes: Class # Class Name (usually the course name, M 170 for instance) Start Date End Date Meeting time (9:30 am ~ 12:15 pm, for instance) Days in a week (Monday) Term (Spring 2018, for instance) Location (TIE Building for instance) Room (UB 301, for instance) Instructor Online status (online, or in-person) Faculty: Employee Id (001880301, for instance) First Name Last Name Title (professor, for instance) Email Phone Office Location (TIE building, for instance) Room (UB303, for instance) Student: Student ID First Name Last Name Plan Sub Plan Advisor Current GPA Grade of each course The Term you got the grade for a course. The class…
Answer in your own way
Y3 In the team project you will essentially go through the stages of database development to solve an information need. It can be something in your work environment, for another organization, or a case that you make up. We will be using the Oracle Database management system (DBMS) for the projects. You will get additional information as the class progresses. The objective of this deliverable will be to notify stakeholders of the topic chosen for the group project. This deliverable will not be graded but it must be submitted and approved before you can proceed with the project. This is a brief (1-2 pages) document that must include the following information: Title of the project Project overview A brief statement, in common language, of the background and objectives of the project, including the problem you are attempting to solve or the opportunity for improvement that you hope to exploit. A description of a business situation:Describe briefly mission statement…
QUESTION 1 15 points We have been asked to develop a database system for a tourism office. The system needs to keep information about customers, cities around the world and hotels in these cities. Each city has name, country and weather that is made up of average temperature in summer and average temperature in winter. Different cities can have the same name in different countries, but for one country the city names are unique. For each city, the system needs to keep information about the number of hotels in the city. For each hotel, the system must store the hotel name (which is unique for a given city), rating, contact (Email, Telephone, fax) and hotel address. The hotel rating is an integer number between 1 to 5, where 1 indicates a very low rating and 5 indicates a very high rating. For each hotel we need to store the number of rooms for each type, for example: a hotel may have 20 rooms of type single and 15 rooms of type double. The system also store the reservations made by the…