Question: Create a Books database to include two tables: BookTable and Course- BookTable. The BookTable table should have fields for ISBN number, title, copyright date, primary

Create a Books database to include two tables: BookTable and Course- BookTable. The BookTable table should have fields for ISBN number, title, copyright date, primary author, publisher, and number of pages. The CourseBookTable table should have fields for course number and ISBN. Populate the tables with books in your current collection, including the books you are using for your classes. Books that are not associated with a specific course can be placed in the table with a FUN course number. The type of database (SQL Server or Access) will be determined by your instructor. Write a C# program to display the course number (or FUN) and the ISBN and name of the book on the same screen. Use MS-Access DBMS to create your database.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

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

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Create a Books database to include two tables: BookTable and CourseBookTable. The BookTable table should have fields for ISBN number, title, copyright date, primary author, publisher, and number of...

Project Project,Overview:, The goal of this project is to use JDBC to create a Books database, populate it, and then execute different SQL statements to query or manipulate the Books database. In the...

Oracle SQL Questions: ( I have answered the questions and the first two statements work, but I keep getting errors with the 3rd and 4th statement). 1. Creation of an audit table which will be...

Instruction for database A-E Creating a Logical E-R Diagram To build an entity, use a rectangular box with two columns. Put the name of the entity in all-caps in the header. Below that, list each...

Here is the script given: Looking for the answer to the Advanced Challenge Quetion. CREATE TABLE warehouses (wh_id NUMBER(2), location VARCHAR(12) ); INSERT INTO warehouses VALUES (10, 'Boston');...

i want complete solution for my assignment and it should be without plagiarism COIT20274: Information Systems for Business Professionals, Term One 2016 Assignments 1 & 2 Requirements Assignment 1 -...

Unit 6 Lab - SQL statements - Need help on these CIS 338: SQL/Oracle Learning Unit 6: Lab Activity Lab Activity Complete the following SQL exercises using the JustLee Books database. Launch Oracle...

a) How many two-factor unordered factorizations, where each factor is greater than 1, are there for 156,009? b) In how many ways can 156,009 be factored into two or more factors, each greater than 1,...

Propane gas at 1 bar and 308.15 K (35C) is compressed to a final state of 135 bar and 468.15 K (195C). Estimate the molar volume of the propane in the final state and the enthalpy and entropy changes...

EVOLUTION CONNECTION Evolution in insects and vertebrates has involved the repeated duplication of body segments, followed by fusion of some segments and specialization of their structure and...

Problems and Short Answer Questions: Show your work where appropriate. 8.) A steel thick walled container contains 5 ft of butane at 20 atm and 300 F. (0F = 460R, 1 atm = 14.696 lb/in, R= 1545.3 ft...

Imagine that the U.S. Congress, recognizing the importance of being well dressed, started giving preferential tax treatment to clothing insurance. Under this new type of insurance, you would pay the...

Find some information on an index fund (such as the Vanguard Total Stock Market Index, ticker symbol VTSMX). How has this fund performed compared with other stock mutual funds over the past 5 or 10...

According to an old myth, Native Americans sold the island of Manhattan about 400 years ago for $24. If they had invested this amount at an interest rate of 7 percent per year, how much would they...