Entity Relationship Diagram

2. ERD (Entity Relationship Diagram) You will develop the entity relationship diagram (ERD) for your project database based on the initial data requirements. The company that we are working on distributes many products, like secure bolts and screws, to many different construction companies. In order for the company to b ...continues

Use of company database applications

Please assist with the following: Analyze the use of databases in your organization. Include what database applications are used (Microsoft Access, DB2, Oracle, etc.). Conclude by proposing improvements. For large organizations, restrict the scope to the department in which you work. If you are not employed, consider the ...continues

Database processing

I'm reworking some online college homework and I can't get these questions. 1. Which of the following is not a step in the database design process? Creating tables and columns from entities and attributes Selecting primary keys creating constraints and triggers 2. When an entity has a relationship to itself, we ha ...continues

Draw an object-oriented data-model

Draw an object-oriented data-model, with all appropriate notation, to represent the following situation. In a particular region there are a number of gardens. One attribute of GARDEN is its LOCATION. A method must be included in GARDEN to calculate its acreage (CalculateAcreage). Each garden is a collection (or assembly) of plan ...continues

Normalize the following relation to 3NF

Normalize the following relation to 3NF. Describe all normal forms, and what must be done to achieve each. Make Computer Company Computer Store PC-1 BUSY BUSINESS MACHINES JOYLAND PC-2 BUSY BUSINESS MACHINES DATALAND PINEAPPLE COMPUTERS INFOWORLD WIZ-1 ...continues

Writing SQL statements

I'm not grasping the full concept of these problems, I've completed most successfully. I've tried to get them, but I am have a hard time reworking these. (This is the table referenced for the following questions) INVENTORY (SKU, Description, QuantityOnHand, QuantityOnOrder, Warehouse) 1. Write a SQL statement to displ ...continues

Describe object-oriented databases

1. Describe Object-Oriented databases. Include a description of objects and their potential contribution to I/S. 2. Describe the database planning and development process. What steps are involved, and what tools may be appropriate or helpful?

Draw an E-R diagram

Draw an E-R diagram with all appropriate notation for the following situation. In a particular fruit-growing region there are a number of orchards. Each ORCHARD is identified by its LOCATION. In general, each orchard contains a large number of trees (assume that an orchard must contain at least one tree). A TREE entity has the a ...continues

Create a data file GRADES with records of the form

Input names of students from the user, terminated by ZZZ, and create a data file GRADES with records of the form: student (string), test1 (integer), test2 (integer), test3 (integer) In this file, all test scores should be set equal to 0. For this problem, use the top-down modular approach and pseudocode to design a suit ...continues

SQL - Assume that tables T1 and T2 have a 1:1 relationship.

Assume that tables T1 and T2 have a 1:1 relationship. Assume that T2 has the foreign key. Show the SQL statements necessary to move the foreign key to T1. Make up your own names for primary and foreign keys.