subject

Using SQL, create the Author, Phone, Book, Publisher, and Member relations as well as any relevant relationship tables (if necessary).Populate them with the information provided below. (Note: this data is comma-separated and contains composite fields that must be broken apart. This will require you to modify the schemas appropriately, as well as to massage the data to handle Great place to do a little programming.) As is usually the case, the data contains extra fields from the ER diagram - I'm looking for you to implement the ER diagram. This data may require other massaging as well to fit into your schemas. Be sure to keep the scripts that create and populate the database - you will need them for future lab assignments.1. Author Data. This data is comma-separated with the following fields: Author ID, Name, Phone numbers2. Publisher Data. This data is comma-separated with the following fields: Publisher ID, Name3. Member Data. This data is comma-separated with the following fields:First line: Member ID, Name, DOBIndented lines: ISBN, Checkout Date, Checkin Date (if no Checkin Date, book is still checked out)4. Book Data This data is comma-separated with the following fields:First line: ISBN, Number of Copies, Shelf, Floor, Title, Publisher, Date PublishedIndented line: Authors

ansver
Answers: 2

Other questions on the subject: Computers and Technology

image
Computers and Technology, 22.06.2019 12:00, savjk74
Which of the following “invisible” marks represents an inserted tab?
Answers: 1
image
Computers and Technology, 22.06.2019 13:00, mariahrpoulin9630
Which part of the cpu accepts data?
Answers: 1
image
Computers and Technology, 23.06.2019 01:40, hanjonez
Writing a modular program in visual c++. i am new to this and not sure what i am missing. i am getting the following error: baddate. cpp: in function ‘int main()’: baddate. cpp: 50: 3: error: ‘else’ without a previous ‘if’elsehere are the instructions and code: writing a modular program in c++in this lab, you add the input and output statements to a partially completed c++ program. when completed, the user should be able to enter a year, a month, and a day. the program then determines if the date is valid. valid years are those that are greater than 0, valid months include the values 1 through 12, and valid days include the values 1 through 31.notice that variables have been declared for you. write the simulated housekeeping() function that contains the prompts and input statements to retrieve a year, a month, and a day from the user. include the output statements in the simulated endofjob() function. the format of the output is as follows: month/day/year is a valid date. ormonth/day/year is an invalid date. execute the program entering the following date: month = 5, day = 32, year = 2014. record the output of this program. execute the program entering the following date: month = 9, day = 21, year = 2002. record the output of this /* program name: baddate. cppfunction: this program determines if a date entered by the user is valid. input: interactiveoutput: valid date is printed or user is alerted that an invalid date was entered*/#include bool validatedate(int, int, int); using namespace std; int main(){// declare variablesint year; int month; int day; const int min_year = 0, min_month = 1, max_month = 12, min_day = 1, max_day = 31; bool validdate = true; // this is the work of the housekeeping() method// get the year, then the month, then the daycout< < "enter the year"< > year; cout< < "enter the month"< > month; cout< < "enter the day"< > day; // this is the work of the detailloop() method// check to be sure date is validif(year < = min_year) // invalid yearvaliddate = false; else if (month < min_month || month > max_month) // invalid monthvaliddate = false; else if (day < min_day || day > max_day) // invalid dayvaliddate = false; // this is the work of the endofjob() method// test to see if date is valid and output date and whether it is valid or notif(validdate == true); {// output statementcout<
Answers: 1
image
Computers and Technology, 23.06.2019 13:00, dimondqueen511
Which one of the following voltages should never be measured directly with a vom? a. 1200 v b. 500 v c. 800 v d. 100v
Answers: 2
You know the right answer?
Using SQL, create the Author, Phone, Book, Publisher, and Member relations as well as any relevant r...

Questions in other subjects:

Konu
Mathematics, 01.12.2020 23:10
Konu
Arts, 01.12.2020 23:10
Konu
English, 01.12.2020 23:10