Question-conceptual design

Assignment Help Basic Computer Science
Reference no: EM131111336

Question: Conceptual Design

Perform conceptual design for the TCI. You are required to generate an ER diagram. And you also need to write the specification that includes additional constraints not shown on the diagram. The specification should be written in English. If you believe that you need to make additional assumptions, clearly state them.

TCI assembles computers and sells them to clients.

Each computer has a unique serial number, its CPU speed, memory size, price, and DVD speed. There are three different types of computers: laptops, desktops, all-in-ones. For laptops, we need to record their size; for desktops, we need to record their monitor size; for all-in-ones, we need to record their size and weights.

Each computer belongs to at most one warrantee policy type, while each warrantee policy type covers many computers. Every computer doesn't have to have a warrantee, and we may have some warrantee policy that does not cover any computer at all. For each policy type, we want to record its policy ID, name, and length. The length of a policy can only be one year, two years, or six years.

We want to keep the following information about our employees: their name (including first and last name), a unique EID, their address, phone number (we only store one number), and their age.

One employee can assemble many computers, and one computer can be assembled by many employees together. A computer has to be assembled by at least an employee, and an employee has to assemble at least one computer. For the assembling activity, we need to record how many hours each employee spent on each computer.

Reference no: EM131111336

Calculate access time when there is cache miss

Calculate the access time when there is cache miss? Suppose that cache waits until line has been fetched from main memory and then re-executes for a hit.

Free presentation software

1. Create and save a document named Free PresentationSoftware.pdf 2. Use the document formatting outlined in the syllabus and create a heading called Free Presentation Softwar

Calculate worst-case computational complexity of decision

It is important to calculate the worst-case computational complexity of the decision tree algorithm. Given data set, D, the number of attributes, n, and the number of traini

Create a program that asks user for number between 1 and 100

Develop a JavaScript solution to the follow problem: Create a program that asks a user for a number between 1 and 100, the program should then output to the user higher, low

Create a table names students with the fields

1.) Create a table names STUDENTS with the following fields (all fields are required unless specified. Do not change the field names, data types or data sizes - follow direc

Can you spot a trend in the frequencies

Modify the program so that it prompts the user for a file name. The numbers in the files have comma separators, so modify the program to handle them. Can you

Cases for a university library borrowing system

Create a set of use cases for a university library borrowing system. (Do not worry about catalogue searching, etc.) The system will record the books owned by the library and

Football stadium that seats a maximum

Goliath State University (GSU) has a football stadium that seats a maximum of 80,000 fansand is sold out for every home game. The price of a ticket to attend a GSU football


Write a Review

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