Question 1:- You have been assigned to design the database for a new soccer club. Indicate the most appropriate sequence of activities by labeling each of the following steps in the correct order. (For example, if you think that "Load the database" is the appropriate first step, label it “1.") Create the application programs. Create a description of each system process. Test the system. Load the database. Normalize the conceptual model. Interview the soccer club president. Create a conceptual model using ER diagrams. Interview the soccer club director of coaching. Create the file (table) structures. Obtain a general description of the soccer club operations. Draw a data flow diagram and system flowcharts.

Question 1:- You have been assigned to design the database for a new soccer club. Indicate the most appropriate sequence of activities by labeling each of the following steps in the correct order. (For example, if you think that "Load the database" is the appropriate first step, label it “1.") Create the application programs. Create a description of each system process. Test the system. Load the database. Normalize the conceptual model. Interview the soccer club president. Create a conceptual model using ER diagrams. Interview the soccer club director of coaching. Create the file (table) structures. Obtain a general description of the soccer club operations. Draw a data flow diagram and system flowcharts.

Database Systems: Design, Implementation, & Management

12th Edition

ISBN:9781305627482

Author:Carlos Coronel, Steven Morris

Publisher:Carlos Coronel, Steven Morris

Chapter9: Database Design

Section: Chapter Questions

Problem 7P

See similar textbooks

Similar questions

Access path A database table is composed of records and fields hold data. Data is stored in records. A field is a part of a record and contains a single piece of data for the subject of the record. The access path for finding the list of books is AUTHOR: AuthorID, Lname BOOKAUTHOR: AuthorID, ISBN BOOKS: Pubdate, ISBN
A new sales ordering system needs a relational database that contains a customer table, a product inventory table, and an order table. Use a word-processing, graphics, or spread-sheet program to draw an entity-relationship diagram showing the relationships among these entities. Next, design each of these tables showing the keys and attributes to be included in each table. Include five sample records for each table.
which step involves database designer activating effects and attributes in the database. a) Maintance b) Development c) Discovery d) Implementation
Design a survey form of your own. Fill it out as it might have been completed during the database design for Premiere Products. For any questions you have too little information to answer, make a reasonable guess.
142. The objects in database description is called a. concept construct b. entity construct c. schema construct d. attribution construct
Question Description of the project A city college would like to maintain their academic information in a MySql database system. The following are the interested information: Courses: Catalog # (M 170 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…
P2
Draw ER (or EER) diagram: A conceptual database design for a chain of furniture stores is needed. The following is a summary of the database requirements: a) The chain has many different stores in various cities and states. Each STORE has unique StoreNumber, plus an Address(made up of Street, City, State, ZipCode), and a StoreManager (who is an employee). Each store is organized into a number of departments. b) Each DEPARTMENT contains certain types of furniture (such as ‘dining’, ‘living room’, ‘bedroom’, ‘office’, etc.), and has a DeptName that is unique within each store; it also has a DeptManager (who is an employee), and a number of SalesPersons (who are employees). c) The company employs many employees. Each EMPLOYEE has a unique SSN, plus a Name (made up of FirstName, Minit, LastName), a job (e.g. ‘store manager’, ‘dept manager’, ‘sales associate’, ‘sales person’, etc.), plus DateOfBirth, Sex, Salary, and CommissionRate. Each employee works for a particular store. Design an ER…
Task 1: ER diagram for give scenario Consider building a database for a shopping mall with requirements as follows:  Each product of the shopping mall has a unique project No, and also has a name, a supplier name, a category, a purchase price and a selling price.  Products need to be supplied from suppliers. Each product has one supplier, but a supplier may supply many products for the shopping mall.  Each supplier has a supplier name and address.  A purchase order for product from a supplier has a unique order No, and a date. The order specifies one or more products and their quantities required for a product.  A sales order for product to customers has a unique order No, and a date. The order specifies one or more products and their quantities required for a product  The shopping mall has warehouses. Each warehouse has a warehouse number, an address and a contact phone number. Each warehouse has shelves to store products. Each shelf has a shelf-number and a capacity. The shelf…
1. Create an EER diagram to show the following information about a university database: Professors have an SSN, a name, an age, a rank, and a research specialty. Projects have a project number, a sponsor name (e.g., NSF), a starting date, anending date, and a budget. . Graduate students have an SSN, a name, an age, and a degree program (e.g., M.S.or Ph.D.). . Each project is managed by one professor (known as the project’s principalinvestigator). . Each project is worked on by one or more professors (known as the project’s co-investigators). . Professors can manage and/or work on multiple projects. . Each project is worked on by one or more graduate students (known as the project’sresearch assistants). . When graduate students work on a project, a professor must supervise their work onthe project. Graduate students can work on multiple projects, in which case they willhave a (potentially different) supervisor for each one. . Departments have a department number, a department…
Create a class diagram for the Sports Physical Therapy database, as shown in Figures 1-21 through 1-24 in Chapter 1. If you need to make any assumptions when preparing the diagram, document those assumptions.
Store Database - Create a database with all needed tables for a store that contain product information, sales information, and customer information. Build relations among the created tables as needed. - Create a view of the customer table showing only some information about the customers.