Question: Your supervisor, Jesse Baker, has asked you to begin working on data design tasks for the new information system, which will be implemented as a

Your supervisor, Jesse Baker, has asked you to begin working on data design tasks for the new information system, which will be implemented as a relational database. You will need to identify the entities, draw an ERD, design tables, and add sample data to each table.

1. List all the entities that interact with the TIMS system. Start by reviewing the data library, previous e-mail messages, DFDs, and other documentation.

2. Draw an ERD that shows cardinality relationships among the entities. Send the diagram to Jesse.

3. For each entity, Jesse wants to see table designs in 3NF. Use standard notation format to show the primary key and the other fields in each table.

4. Jesse wants to use sample data to populate fields for at least three records in each table. Better get started on this right away.

Step by Step Solution

★★★★★

3.35 Rating (164 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

1 Based on the overall fact situation list of entities that includes the following submitted STUDENT INSTRUCTOR TRAINING ADMINISTRATOR CORPORATE CLIENT COURSES In addition the ACCOUNTING SYSTEM can be ... View full answer

Question Has Been Solved by an Expert!

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

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

200-B-M-A-C-S-D (500).docx

120 KBs Word File

Students Have Also Explored These Related Managerial Accounting Questions!

The controller of Pantops Corporation has asked you to prepare a factory overhead variance report for the Finishing Department on an item by item of cost basis. You have been supplied with the...

Your boss has asked you to prepare a feasibility report to determine whether the company should advertise its custom-crafted cabinetry in the weekly neighborhood newspaper. Based on your primary...

The head of your companys marketing department has asked you to explain to him what is cost of capital and how one would estimate the companys cost of capital You can assume the company is a public...

System Design Project This is a continuing case for Personal Trainer, Inc. Following the decision in the system analysis phase to use an in-house team to develop a design prototype, Susan began to...

Chapter 10 Business Process and Information Systems Development \"Jeff, we clean the clubhouse restrooms twice a day . . . in the morning before 7 and again just before lunch. We've been doing that...

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...

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...

Session 4: Requirements Modeling Overview: The SCR Associates case study is a Web-based simulation that allows you to practice your skills in a real world environment. The firm offers IT consulting,...

Willowbrook Case Study question: Design the monthly billing statement for a family using a printer spacing chart or graph paper. Include a mock-up report and a report analysis form for each report ....

A large online retailer has set up a private web space to sell to its customers that are businesses. These transactions are generally conducted through negotiated contracts. How does the company use...

Using the method of Sec. 11.8, derive the formula x = x0 + v0t + at2 for the position coordinate of a particle in uniformly accelerated rectilinear motion.

Figure includes a box for the econometrics unit. Item (3) is to help other units. What sorts of specific tasks might thisentail? Customers Product Final Risky Portfolio Feedback Overall Portfolio...

Cameron has a basis in his partnership interest of $ 5 , 0 0 0 . Cameron's share of partnership income is $ 5 , 0 0 0 . He also receives a cash distribution from the partnership of $ 1 3 , 0 0 0 ....

10. Explain the importance of formula (8.5): s2t otal 5 s2 process 1 s2 measurement

Design the Purchase Web page for Sludges Auto. Assume that the customer has been added and has been logged on. Display some information about the customer. Split credit card information (type of...

Design a Web page using Ajax for registering an electronic product, either hardware or software. The form should have the purchasers name and address, telephone number, email address, and a dropdown...

Pooling information from the output design and reviewing their progress, Chip and Anna proceed to the next stage, the design of input. Web pages must be designed to capture input information easily...

You are the marketing director of KFC fast food restaurants. Your company is expanding overseas and you have been asked to study the culture and customs of Japan to determine how to best serve the...

Descriptive Statistics help with the explanation 13) (10 points)_Hotel Costs The table shows data based on a 2009 report by Travel + Leisure magazine for a sample of 12 luxury hotels in the US. It...

Mikaella Zevallos 10/17/21 1:49 PM Homework: Assignment 18: 6.2 HW Question 13, 6.2.27-T HW Score: 91.75%, 19.27 of 21 points Co Part 3 of 3 O Points: 0 of 1 Save A survey found that women's heights...