Basics AutoCare is a small auto service business with two locations in a Midwest (U.S.) city. The business is based on providing
routine maintenance at fixed cost to car owners. The owners have decided to computerize their operations to allow them to better track their business. Data to be gathered for each service visit includes service ID, service item, service item cost, vehicle owner, owner telephone number, vehicle make and model, vehicle year, and date of service.Assignments:1. Create an ERD for the auto service system.2. Create 3NF table designs for the system.3. For each of the entities identified, design tables and identify the possible candidate keys, the primary key, a probable foreign key, and potential secondary keys.4. Use sample data to populate the fields for three records.
1 answer:
You might be interested in
Answer:
I am writing a C++ code.
#include <iostream> // for input output functions
using namespace std; // identifies objects like cin cout
int main() { //start of main() function body
string c_string; // stores the string entered by user from land water or air
int land=0; // contains the number of times land string is read in
int air=0; //contains the number of times air string is read in
int water = 0; //contains the number of times water string is read in
cin>>c_string; //reads the string entered by user from air water or land
/*while loop continues to execute until user enters xxxxx or maximum length of a string exceeds 8 */
while(c_string!= "xxxxx" && c_string.length()<=8) {
if(c_string=="land"){ // if string entered by user is land
land = land + 1;} //counts and increments each occurrence of land string by 1
else if(c_string=="air"){// if string entered by user is air
air = air + 1;}// counts and increments each occurrence of string air by 1
else if(c_string=="water"){// if string entered by user is water
water = water + 1;}//counts and increments each occurrence of air by 1
cin>>c_string;}
/* keeps reading the string entered by user from land air or water, until the loop breaks after the user enters xxxxx or user enters a string whose length is greater than 8 */
//prints the number of times land, air and water are read in
cout << "land:"<<land;
cout << endl<<"air:"<<air;
cout << endl<< "water:"<<water; }
Explanation:
Everything is well explained in the comments above.
The program prompts the user to input strings. These strings are either land air or water. The while loop continues to read the input strings until user enters xxxxx or the string entered by user exceeds the length 8. Both these terminating conditions are added in the while loop. After the loop terminates, the number of times land, air and water strings are read is displayed on the output screen. Any other string entered by user other than these 3 is ignored. The program along with the output is attached.
