Complete the requirements using dbdl

Assignment Help Basic Computer Science
Reference no: EM13547647

The State has contracted you to build a database for their bookstores.
The State operates fifteen Community College Bookstores where they currently store information about the Colleges, Publishers, Authors, and Books.
You have been given the task of automating the antiquated process the bookstores is currently using.
Each one of the fifteen Community Colleges has a unique number as an identifier, a College name, College location and bookstore employees.
Each publisher has a Name, City and a code that uniquely identifies the publisher.
After talking with the employees and studying the data needs of the bookstore, it has been determined that they need to access and report on the following information:
Requirement 1: For each publisher, list the publisher code, publisher name, and the city in which the publisher is located.
Requirement 2: For each college, list the number, name, location and number of employees working at the bookstore.
Requirement 3: For each book, list its code, title, publisher code, publisher name and price.
Requirement 4: For each author, list its author(s) name. A book could have more than one author.
Complete the requirements using DBDL and create Diagram. Make sure all tables are normalized to 3NF and exhibit proper relationships.

Reference no: EM13547647

Questions Cloud

Open a new database in microsoft access : Open a new database in Microsoft Access
Writing a program to maintain the student database : Writing a program to maintain the student database
A company named rl medical imaging : For this course, your projects will be for a company named RL Medical Imaging (RLMI).
What are some of the important considerations regarding dbms : What are some of the important considerations regarding DBMS/Database design? Explain why these considerations are important.
Complete the requirements using dbdl : Complete the requirements using DBDL and create Diagram. Make sure all tables are normalized to 3NF and exhibit proper relationships.
Design a database application to keep track of movies : Design a database application to keep track of movies, actors, and the roles played by actors in movies. You may make up all the data.
File name according to the section of the assignment : File name according to the section of the assignment
Explain how you would apply the six sigma approach : When a senior product inspector at Plush Packet Inc. (PPI) inspected a shipment of Router the Raccoon plush toys she discovered that, on average, 15 of the 50 toys in every box had defective seams, and in many of the defective toys, the seams w..
The types of information that should be placed in a table : The types of information that should be placed in a table

Reviews

Write a Review

Basic Computer Science Questions & Answers

  Write a program that creates a 4x3 array of integers

Write a program that creates a 4x3 array of integers. Populate the array with random numbers between 0 and 200. Sum up the values in each column and display the three sums to the screen.

  Which data input appears on output y

View a datasheet function table for a 74151 device. Using Quartus pin names, assume the chip is enabled and C = 1, B = 0, and A = 0. Which data input appears on output Y?

  How to create a flex program

My assignment is to create a flex file, Can someone take me step by on how to create a flex program. I'm using netbeans.

  Every program in a system contains

Assume that every program in a system contains 40,000 machine code instructions. To execute an instruction it takes 4 machine cycles. Assume that a computer constantly keeps 150 active processes in execution and each active process needs to be exe..

  Use an open-addressed hashing table of size m

1)Suppose that we use an open-addressed hashing table of size m to store n ? m / 2 items. Assuming uniform hashing, show that for i = 1, 2, ..., n, the probability is at most 2?k that the i-th insertion requires strictly more than k probes.

  Prompts the user for the prices of 10 automobiles

Write a program that prompts the user for the prices of 10 automobiles (use looping to do this and store the prices in an array). The automobiles may be priced from less than $1 up to $99,999. No negative numbers are allowed. Perform error checkin..

  Add the form which includes richtextbox control

Add the form which includes RichTextBox control and several predefined template letters. This part of program would be used to write letters to your customers.

  Display the new list as well as the two old list

Display the new list as well as the two old list Thank you in advance.

  How spki be augmented to support policy

Consider a policy that, for reasons of separation of duties, does not allow an entity to exercise the rights it may grant (delegate) to others. How could SPKI be augmented to support such a policy?

  Generate profits often referred to as creating

When the output of some units can be used as inputs to othe units, or if two organizations pools markets and expertise that results in lower costs and generate profits it is often referred to as creating?

  What would be the effects on the business resources

which phase of the SDLC do you think is the most important phase to this business, and why? What would happen if the organization didn't do a good job in that phase? What would be the effects on the business resources of time, money, and people?

  Develop the pseudocode for the program design

Complete the hierarchy chart in Appendix H and the flowcharts in Appendix I, based on the Currency Conversion program requirements and the input-process-output table you generated in Week Two.

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