What is the best approach to conceptual database design

Assignment Help Database Management System
Reference no: EM131113917

Questions 1 through 6 are based on the following scenario.

The ABC Car Service & Repair Centers are owned by the SILENT car dealer; ABC services and repairs only SILENT cars. Three ABC Car Service & Repair Centers provide service and repair for the entire state.

Each of the three centers is independently managed and operated by a shop manager, a receptionist, and at least eight mechanics. Each center maintains a fully stocked parts inventory.

Each center also maintains a manual file system in which each car's maintenance history is kept: repairs made, parts used, costs, service dates, owner, and so on. Files are also kept to track inventory, purchasing, billing, employees' hours, and payroll.

You have been contacted by the manager of one of the centers to design and implement a computerized system. Given the preceding information, do the following:

1. 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.")

Normalize the conceptual model.
Obtain a general description of company operations. Load the database.
Create a description of each system process. Test the system.
Draw a data flow diagram and system flowcharts. Create a conceptual model, using ER diagrams. Create the application programs.
Interview the mechanics.
Create the file (table) structures.
Interview the shop manager.

2. Describe the various modules that you believe the system should include. You may describe the modules with text or insert a graphic.

3. How will a data dictionary help you develop the system? Give examples.

4. What general (system) recommendations might you make to the shop manager? (For example. if the system will be integrated, what modules will be integrated? What benefits would be derived from such an integrated system? Include several general recommendations.)

5. What is the best approach to conceptual database design? Why?

6. Name and describe at least four reports the system should have. Explain their use. Who will use those reports?

7. Suppose you have been asked to create an information system for a manufacturing plant that produces nuts and bolts of many shapes, sizes, and functions. What questions would you ask, and how would the answers to those questions affect the database design?

8. What do you envision the SDLC to be?

9. What do you envision the DBLC to be?

10. Suppose you perform the same functions noted in Problem 7 for a larger warehousing operation. How are the two sets of procedures similar? How and why are they different?

Reference no: EM131113917

Develop conceptual data model diagram

To develop a conceptual data model diagram and to perform logical design and Development Plan applications (here after called as application) that have been received during t

Develop a database based upon the entity relationship model

Develop a Microsoft Access database based upon the below Entity Relationship Model. Be sure to include tables, fields, keys, relationships, and data in your database. Your f

How does access identify each record within a database

How does Access identify each record within a database? What is the benefit for your data entry people by providing their data entries via combo boxes? What is the purpose of

Create a switchboard for your database

Do not use the Main Switchboard page that is provided for you, but rather create a new Switchboard named with your first name and the word Switchboard. (For example,

Rationale for fragmentation choices is clearly tied

Fragmentation strategy-Rationale for fragmentation choices is clearly tied to the facts in the business case. considerations for horizontal, vertical and mixed approaches we

Provide a main program to test the lexical analyzer

The getToken() function should read characters from the stream pointed to by the first argument and return the token that it recognizes. This file should #include p2lex.h and

Construct a b+ tree

Construct a B+ tree for the following set of key value (2,3,5,7,11,19,23,29,31) in ascending order where the pointers that will fit in one node is as follows:A. four B. six

Identify the features of the database using facts and data

Identify the mission statement of the database, what is its role in law enforcement.Identify the features of the database, using facts and data. For example, what data is in


Write a Review

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd