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

  Determine total hours committed by employee

Assume the weekly hours for all employees are stored in the two-dimensional array. Each row records the employee's seven-day work hours with seven columns. Determine total hours committed by each employee every week.

  Create a console-based program and a gui application

Create a console-based program and a GUI application

  Information on the vulnerabilities, threats, and exploits

To assist PVSS, your contract has been expanded to also create a risk assessment. In addition, PVSS management has asked for information on the vulnerabilities, threats, and exploits.

  File format would you choose

What file format would you choose for the following tasks: 1. A cartoon strip 2. A 3D model for use on a multimedia presentation on the web

  Significance of strategic management

Explain the significance of strategic management to support telecommunications planning model.

  Determine whether a string is in the language l

Write a pseudocode function that uses a stack to determine whether a string is in the language L, where a. L= {w : w contains equal numbers of A's and B"s} b. L = {w : is of the form A(n) B(n) for some n >/= 0}

  Consider the time slot relation

Consider the time slot relation. Given that a particular time slot can meet more than once in a week, explain why day and start time are part of the primary key of this relation, while end time is not.

  Use xml and retrieve the stored data using dom parser

project that requires me to use XML and retrieve the stored data using DOM parser. I have it written to the point that it writes regular equations no problem. But I want to include graph using images in the form of JPEG.

  What is the output of this code sequence

What is the output of this code sequence?

  Kinds of system-building methods used by dorfman

Recognize the kinds of system-building methods used by Dorfman to create its wireless warehouse system. Explain the methodologies you would recommend

  Formulating and selecting dss implementation strategies

Discuss the considerations for formulating and selecting DSS implementation strategies.

  Explain advantages of having componentized system

Explain some of the advantages of having componentized system. For instance, What occurs if the microwave breaks?

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