Reference no: EM131302382
Create the database tables, establish keys and constraints, populate data within the database, and queries to the Assignment Files tab.
Submit the presentation including recorded audio speaker notes to the Assignment Files tab Just need it for Supporting Activity DBMS and Data Mining.
A motor vehicle maintenance center wants to improve its services by using database management systems (DBMS) and data mining. What tables are needed in such a database and how can it help improve their services?
To find out what tables are needed; first we need to define the entities and attributes associated with this database. A ERD should be created to show the relationships between the entities and attributes. Since this is a motor vehicle maintenance center trying to improve its services, then the entity should be VEHICLE. The entity is an object of interest to the end user.
The VEHICHLE entity includes the attributes of VEH_MODEL, VEH_MAKE, VEH_YEAR, VEH_COLOR and VEH_VIN among with many other attributes. To make the database more flexible we can assign a primary key (PK) to the VEH_VIN which will act as an identifier. By typing in the vehicle's vin number, this can pull up multiple information from the database. Here is an example from
chapter 4 from Entity Relationship (ER) modeling. Below the diagram a multivalued attribute in an entity.
By implementing these tables, entities and attributes, this will help this maintenance center a great deal because, the employees will be able to work more efficiently, effectively and quicker. This can avoid phone calls to other shops or dealerships trying to locate parts or even locating old filed records on vehicles.
|
Create two adjacent channels
: Create two adjacent channels, which are also OQPSK transmitters limited to the main lobe. Place the adjacent channels as close as possible to the desired channel, without allowing the spectra to overlap.
|
|
Scholarly activity-research methods
: Research how qualitative research is used in your field. Write an essay that describes how qualitative research tools can be used to aid in decision making within your field. Be sure your essay addresses the following questions/topics:
|
|
What is the optimal amount to alter the variance
: What is the best constant to add and how much simulation time does this save you?- What is the optimal amount to alter the variance, and how much execution time does this save you?
|
|
What an applicant should
: Please study what an applicant should and should not do during the job interview. Apply the following guidelines in ALL of your assignments:
|
|
Create the database tables, establish keys and constraints
: Create the database tables, establish keys and constraints, populate data within the database, and queries to the Assignment Files tab.Submit the presentation including recorded audio speaker notes to the Assignment Files tab Just need it for Supp..
|
|
Estimate what fraction of the drops hit the drain
: There is a circular drain in the sink, centered at the origin, of radius 0.1. Using Monte Carlo simulation, estimate what fraction of the drops hit the drain.
|
|
How does a function provide output to the program
: Functions can be thought of as miniature (sub)programs inside of other programs. Like any other program, we can think of functions as having input and output to communicate with the main program.
|
|
Identify and define the fallacy
: Identify and define the fallacy. For example, appeal to tradition, false dichotomy, etc. Explain why this type of fallacy is a bad way of reasoning. Construct an original fallacy argument of that type.
|
|
Compute return on stockholders equity for both firms
: Interpreting results from the Du Pont system of analysis [LO3] Assume the following data for Cable Corporation and Multi-Media Inc. Cable Corporation Multi-Media Inc. Net income $ 30,700 $ 149,000. Compute return on stockholders’ equity for both firm..
|