Question: DATABASE MODELS Your team assignment is to design a database. You do NOT need to build a database using a database tool like MS Access.

DATABASE MODELS

Your team assignment is to design a database. You do NOT need to build a database using a database tool like MS Access. Instead, you will design a database by creating a database model. As you may recall from class, a database model describes which manner data can be stored, organized and manipulated.

Assume you are the owner of a company or organization. Your task is to design a database to store information relevant to your business operation. You can be in any industry you like. Examples of industries could include, but are not limited to, Education, Healthcare, Food and Beverage, Banking, Hospitality, Energy, Shipping, or Human Resources. Decide as a team on your industry.

Requirements for the data model:

-Your database model should consist of at least 5 entities

-Each entity should consist of at least 3 attributes (up to 7 is encouraged)

-Provide at least two records (as examples) for each entity to illustrate how data would be stored

-Identify relationships between entities

Assume that the database model is for a relational database.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Design Review - Beginning of Individual Case Study The review session with your instructor is worth 10 points. Items to be covered include concurrence on the 3 tables (you propose), fields making up...

Mary and Mike Miller own a chain of Mini dealerships throughout Colorado. They have used systemsin the business for several years to handle payroll, typical accounting functions, and customer order...

Use the following Case study to construct an entity relationship model. Define your entities, label your relationships, determine the cardinalities, and list the attributes. Be sure to indicate your...

Miller Mini Dealerships Case Study 25 points Mary and Mike Miller own a chain of Mini dealerships throughout Colorado They have used systems in the business for several years to handle payroll ,...

London School of Science & Technology Qualification Unit number and title BTEC Level 5 HND Diploma Business UNIT 6: Business Decision Making Student name and ID number Assessor name Al Hassan Barrie...

PLEASE READ CAREFULLY THE CASE STUDY PROVIDED AND FEEL FREE TO ADD HERE YOUR COMMENTS FOR EXAMPLE LIKES DISLIKES WORDS OR PHRASES YOU DO NOT UNDERSTAND ANY COMMENTS THAT WILL IMPROVE THE DIALOGUE...

PROJ592 COURSE PROJECT GUIDELINES Course Project Part 1Due Week 1 (graded, 40 points) MS Project Tutorials 5 points 1. Before starting your Course Project assignments, watch the MS Project videos and...

Introduction to Ridgeline Mountain Outfitters (RMO) Ridgeline Mountain Outfitters (RMO) is a large retail company that specializes in clothing and related accessories for all types of outdoor and...

Synthesys Informatics is a medium sized company that develops and manufactures mobile data collection devices. You are an employee of Synthesys and work as project manager in the product development...

In March, Roland had revenues of $619,000 fixed costs of $216,450, and a profit of $62,100. Answer the following questions: Required: a. What was the contribution margin ratio? b. What monthly sales...

From his analyst, the investor learned the following figures: One hryvnia invested in Bet Cone, on average, brings 30 kopecks of profit with a standard deviation of 10 kopecks, invested in Hair Team...

Support department costs are applied to product costs asO overhead.Ofixed selling and administrative costs.Ovariable cost of goods sold.Ofixed manufacturing costs.

Read chapter Seven Power and Politics Essentials of Organizational Behavior: An Evidence - Based Approach by Terri A . Scandura and submit your summary on time.

=+Select a client, or advertise your advertising services, or your new company's website. Some students and creative talents are developing websites, writing copy, shooting videos, and so on. Create...

=+Part 3 Write copy for one page. You could choose the home page, or about the company, or case study, or whatever page you want. Be sure to include headlines and subheads for each page.

=+AdWord users, and for seasoned pros: http://www.google.com/adwords/smallbusinesscenter/write-great-ads.html.