Question

Description Design a database that contains 3-5 related tables to model a scenario of your intere...

Description

Design a database that contains 3-5 related tables to model a scenario of your interest. You should be somewhat familiar with the scenario that you choose to make informed design decisions. For example, if you want to design a database for a small business, you need to know the business logistic in the company. Other examples for your database are a database for a bookstore, a gym (e.g., YMCA), or a small organization.
Do step 1

Step 1: Write a description of the business for which you are creating the database. You must include how the business will be using your database, what data are being stored in your database. The description should not be longer than one page. In addition, create a data dictionary for each one of your relations. The number of pages for the data dictionary depends on the number of tables and the size of the tables you have. There is no page limit for the data dictionary. See the table below as an example.

Relation: Employees
Field Name Data Type Field Size Description Example
Name Text 30 Full name John Doe
DateHired Date/Time The date the employee was hired 2018-01-01
HourlyRate Decimal 3.2 The hourly rate 12.5
MaxHours Integer 3 Maximum number of hours per week 25
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Domau1 了) Ev.tpiyead (nu 벼he.Ca)) polmo.yk )Sayu)) nunbar (30) Pmary kes oain tables Mere haue Relds like Employee Tal (nurb

tones 少+ Here the Yn Unter/ R columns can be

Add a comment
Know the answer?
Add Answer to:
Description Design a database that contains 3-5 related tables to model a scenario of your intere...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Project Description In this project, you will design and implement a database for keeping track of...

    Project Description In this project, you will design and implement a database for keeping track of information for an online “SOCIAL NETWORK” system (e.g. a simplified version of Facebook!). You will first design an EER schema diagram for this database application. Then, you will map the EER schema into a relational database schema and implement it on ORACLE or MySQL or some other relational DBMS. Finally, you will load some data into your database (via user Interface) and create some...

  • In your own words, explain the difference between a flat file and a relational database. (5...

    In your own words, explain the difference between a flat file and a relational database. (5 points) Review the example Hospital Physician Data Dictionary as found in your Lecture this week. Create a similar Data Dictionary for Patients, using the same format. Include at least 5 field names you think should be included in a Patient Data dictionary. Remember to use different data types for dates, text, and numbers. I have given you two examples to start. (10 points) Field...

  • database design class for database and design class discription for the first pic discription Using the...

    database design class for database and design class discription for the first pic discription Using the descriptions in the ER diagram exercises you selected in the course content area, develop an ER diagram for your assigned exercise. The order of construction should be: Entities Identifiers Attributes (when listed in the exercise) Relationships Please use Crow's Foot Notation for your diagrams. Upon completion, post both the description of your exercise and an image of a completed ER diagram to share with...

  • Project Description: An independent real estate firm that specializes in home sales needs to create a database in which...

    Project Description: An independent real estate firm that specializes in home sales needs to create a database in which to store its records. In the following project, you will open a database containing information about the properties the real estate firm has listed. You will work with a table in which to store agent information, and then sort the table. You create a relationship between two tables and enforce referential integrity. You also apply filters, sort a table, and save...

  • Question 4. ER model (5 points). You are asked to design the ER diagram for a database to manage ...

    Question 4. ER model (5 points). You are asked to design the ER diagram for a database to manage data for athletes athletic game. Requirements are as follows: Each participating team has a name and a manager. Each athlete has a unique athlete ID, and is also described by first name and last name, gender and age. A team has many athletes but an athlete only belongs to one team. Each sport has a unique code and some sport name....

  • The lab for this week addresses taking a logical database design (data model) and transforming it...

    The lab for this week addresses taking a logical database design (data model) and transforming it into a physical model (tables, constraints, and relationships). As part of the lab, you will need to download the zip file titled CIS336Lab3Files from Doc Sharing. This zip file contains the ERD, Data Dictionary, and test data for the tables you create as you complete this exercise. Your job will be to use the ERD Diagram found below as a guide to define the...

  • You were requested to design a database to store the data concerning a large mechanic shop....

    You were requested to design a database to store the data concerning a large mechanic shop. Your database has to store the following: For each car, you want to store the make, model, year, color, engine info, license plate, VIN (vehicle identification number), and a field for general notes. Additionally, for each car, you need to keep information about the owner. For each owner, you need to store the client ID, the name, address information, phone number, and email. An...

  • Database design Part One (Conceptual Database Design) As a database developer, you have been asked to...

    Database design Part One (Conceptual Database Design) As a database developer, you have been asked to design a new database the operation of the new project within the Liverpool John Moores University (LJMU). LJMU i planning to deliver a number of professional training courses in Al. Each course is delivered by one member of staff at LJMU's Training Centre; each staff is allocated a staff number. The policy of LJMU is to record the start working date of each staff,...

  • Step 1: Design and create the tables You must create additional tables to hold Project and...

    Step 1: Design and create the tables You must create additional tables to hold Project and Activity Data. A project represents the construction of a facility with a limited scope of work and financial funding. A Project can be composed of many activities which indicate the different phases in the construction cycle. Example Project Name: Bobba Fett’s Bounty Chase Ride An activity represents the work that must be done to complete the project. Example Activity Name: For Example activity name...

  • Your project will require you to develop a database design to solve a real-life data management...

    Your project will require you to develop a database design to solve a real-life data management problem. It can be any problem in your work environment or for another organization, for example, a bookstore (think of how Amazon uses databases), a course management system (think of how a university manages courses), a bank (think of how your bank works), and an online auction site (think of how Ebay works). You will develop a database to solve this problem You will...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT