ERD

Need Help in Entity Relationship Diagram ERD Assignment?
We can help you if you are having difficulty with your Entity Relationship Diagram (ERD) Assignment. Just email your ERD Assignments at admin@assignmentcache.com.
We provide help for students all over the world in Entity Relationship Diagram Assignment.

Items 11 to 20 of 32 total

per page
Page:
  1. 1
  2. 2
  3. 3
  4. 4

Grid  List 

Set Ascending Direction
  1. IM300 Week 4 Hotel Database Part 3 DDL script

    IM300 Week 4 Integrity and Constraints Hotel Database Part 3

    Regular Price: $25.00

    Special Price: $20.00

    IM300 Week 4 Integrity and Constraints Hotel Database Part 3


    Resources: SR-bi-003 – Hotel Database, the results from SR-bi-003 – Hotel Database Parts 1 & 2, Oracle® Database Express® and Microsoft® Visio® Virtual Desktop.


    Complete Service Request SR-bi-003 - Hotel Database–Part 3.


    Normalize the entities and attributes to at least the third normal form.


    Use Microsoft® Visio® diagramming tools to create an entity-relationship diagram (ERD) that demonstrates the logical design of your normalized database.


    Create and alter tables in the city’s Oracle® Database Express® database to implement the ERD design.


    Generate a new DDL script.


    Create a fax cover sheet addressed to the project manager for the ERD and a newly generated DDL script to show your progress on the project.

    Learn More
  2. CMIS 320 Lab 1 Homework Data modeling diagram

    CMIS 320 Lab 1 Homework Data modeling diagram

    Regular Price: $15.00

    Special Price: $12.00

    CMIS 320 Lab 1 Homework Data modeling diagram


    Homework Submission Requirements:
    Homeworks should be submited as an attached file in your assignment folder. text for coding and result of execution and MS Word format for documenting are preferred. Data modeling diagram could be copied and pasted into a Word doc.
    You must name your file to include your first initial of your first name and last name.
    Part I is 4 points and Part II is 1 points. Total is 5. Quiz is not required for grading.


    Part I: Data Modeling
    Consider a student club or organization in which you are a member. What are the data entities of this enterprise? List and define each entity. Then, develop an enterprise data model showing these entities and important relationships between them. (See figure 1-3a on page 11 for an example enterprise data model)


    Part II: Lab 1
    In this class, we need a functional database system to complete the tasks, such as project 2 and Learning SQL. The school provides you with an Oracle database instance on NOVA unix server for this purpose. You all should have your accounts set up. What you need to do is to activate it for this class.

    Learn More
  3. CMIS 320 Lab 2 Homework 2 Data modeling and Sample database

    CMIS 320 Lab 2 Homework 2 Data modeling and Sample database

    Regular Price: $15.00

    Special Price: $12.00

    CMIS 320 Lab 2 Homework 2 Data modeling and Sample database


    Homework Submission Requirements:
    Homework should be submitted as an attached file in your assignment folder. text for coding and result of execution and MS Word format for documenting are preferred. Data modeling diagram could be copied and pasted into a Word doc.
    You must name your file to include your first initial of your first name and last name.
    Part I is 4 points and Part II is 1 points. Total is 5. Quiz is not required for grading.


    Part I Data Modeling
    For each of the following descriptions:
    a. A piano manufacturer wants to track all pianos it makes. Each piano has a unique serial number and a manufacturing completion date. Each instrument represents exactly one piano model, all of which have an identification number and model. The company produces thousands of pianos of a certain model, and the design is specified before any single piano exists.
    b. A vendor builds multiple types of tablet computers. Each has a type identification number and a name. The key specifications for each type include amount of storage and display type. The company uses multiple processor types, exactly one of which is used for a specific tablet type. The same processor can be used in multiple types of tablets. Each processor has a manufacturer and a manufacturer's unique code that identifies it.
    perform the following tasks:
    1. Identify the degree and cardinalities of the relationship.
    2. Express the relationships graphically with an E-R diagram.
    Document your work into a single, well-organized, well-written word document and submit no later than due date.


    Part II Lab 2
    In lab 2, you will learn how to run a SQL script to create a sample database in your schema in NOVA Oracle database. You also start to learn simple SQL commands, such as select and insert


    Click here to open Lab 2 instruction page


    This part of lab is to learn to run a SQL script on NOVA Oracle database server, and spool screen output to a text file. These techniques will be used when you work on your project 1 and 2. Download script file. This is sql script file containing completed sql commands to create tables and constraints and populate data to each table. The database you create is called JustLee Book Store. The code should be bug free.
    Download lab2.sql script
    Start spool command and run the script:
    Log on NOVA, make a dir named scripts using command mkdir scripts
    Then cd to newly created script directory
    Upload your script to scripts directory using FTP
    (I downloaded a free FTP client CORE FTP LE) and use it to upload and download file)
    Now you have a newly create dir and your script is uploaded. You are ready to run your script.
    Using SQL*Plus, log on NOVA Oracle database with your account
    At SQL prompt,Type the following command to turn on spool function: SQL>spool spool01.lst
    spool01.lst is the spool file name
    Then use this command to run the script: SQL>@lab2.sql
    The command will execute all the SQL commands inside the script and output will be spooled to spool01.lst
    In the script, there are drop table statement as well. When first run, these commands will fail because the tables are not created yet.
    You can run the script multiple times without any problems.
    When you finish the execution, issue command SQL>spool off
    This command will end spool function and save output to the file you defined
    When you have done all of these. Use FTP get spool01.lst to your local computer and submit it as part of homework 2
    You should know how to perform the following tasks using sqlplus on NOVA Oracle database after you complete this lab:
    Using FTP to upload or download a file (scripts...)
    Using sqlplus to log on to NOVA Oracle database
    Using sqlplus command, spool to output screen output to a text file and transfer the file back to your local PC.
    Understand the steps taken place when you perform FTP file transfer and Spooling your output.
    Test the database you create and learn SQL queries.
    You need to spool the execution results of the following commands.
    Do a database query: select table_name from user_tables; USER_TABLES is a database system view that allow users to see the tables they created in their own schema.
    You should be able to list the tables you just created
    use this query: select * from "table_name from the above query"; you can retrieve the data in these tables one a time
    use this query: select count(*) from "table_name from the above query"; you can retrieve the record counts in these tables one a time
    Use SQL*Plus command "desc books" to check columns and their datatypes. And insert one record into the table. Use SQL command "commit" to save the record into your database.
    When you have done all of these. Use FTP get spooled file to your local computer and submit it as part of homework 2

    Learn More
  4. Data Warehouse for Huffman Trucking Maintenance

    Data Warehouse for Huffman Trucking Maintenance

    Regular Price: $12.00

    Special Price: $10.00

    Data Warehouse for Huffman Trucking Maintenance

    An organization has several operational systems: Customer Relationship Management (CRM) for marketing and sales, Enterprise Resource Planning (ERP), and Supply Chain Management (SCM). They also have external customer data. A wide variety of departments utilize this data: sales, marketing, procurement, human resources, R&D, and senior management.

    Design a high-level conceptual view of a data warehouse (DW) for Huffman Trucking Maintenance using Microsoft® Visio® that shows the following:
    Integration layers
    The data warehouse (DW), with a Star Schema showing a Fact table and various dimension tables with all their needed fields and relationships
    Recommended data marts

    Include arrows to show ETL (extract, transform, and load) locations and direction, and paste a screen shot of the above Visio DW Star schema along with the DW description in a Word document.

    Learn More
  5. Muscat Theatre House ERD

    Muscat Theatre House ERD

    Regular Price: $12.00

    Special Price: $10.00

    Muscat Theatre House ERD


    Muscat Theatre House is a place where opera performances are being scheduled. A play is an opera performance acted by different actors/actresses having different roles. A play has id, title, description and category. In every play there will be one or more actors/actresses performing and an actor may perform in any number of plays or may not perform in a given play. Information about actor/actress includes id, name, contact number, nationality, birthdate, and address, which is composed of street number, city, state and country. The role and payment for each actor/actress is also being stored for every play they will perform since these vary from play to play. A schedule is being prepared for each play which details the date and time a play will be performed. A play will be scheduled at least once. Once the schedule is published, customers start reserving seats for a particular schedule or may reserve seat to more than one schedule. A schedule may or may not be reserved by any customer. Information about customer includes id, name and contact number. Whenever a customer reserves for a schedule of a play, it will be identified by a reservation number along with the seat number/s being reserved.

    Learn More
  6. CS251 Fundamentals of Database Systems Week 4 IP The Microsoft Access Database

    CS251 Fundamentals of Database Systems Week 4 IP The Microsoft Access Database

    Regular Price: $20.00

    Special Price: $15.00

    CS251 Fundamentals of Database Systems Week 4 IP The Microsoft Access Database

    Using Microsoft Access create the tables and relationships defined in your data model. Your Microsoft Access Database at this point should include the following:

    The Tables as defined in your Entity Relationship Diagram.
    The Relationships between the tables.
    3 Defined Queries. One of the queried needs to be created to show the data from the Many-to-Many relationship (or include three tables) originally identified from the initial requirements.
    Take a screenshot of the ERD and the Queries.

    Add the Screenshots to the section in your template titled: The Microsoft Access Database.

    Learn More
  7. Gamers ERD

    Gamers Visio ERD

    Regular Price: $20.00

    Special Price: $15.00

    Create ER Diagram with the following information:

    Gamer -user name, password, email, first name and last name; User name is unique; Can create multiple characters
    Character -name is unique. Needs to show current level, exp points, health points, magic points, strength, intelligence, dexterity, belong ONLY ONE class. 3 classes: warrior, mage, ranger
    Items (for character)- name, type, value, status (0 to 100, 100 is new and 0 is broken), 3 Items (weapon, armor, accessory) Many Character can have the same item of same name, but not same individual item
    Weapon - type, speed, damage
    Armor - defense value, type
    Accessory - type, special effect
    Character Skill - name, Magic Point cost of skill, level requirement, description (multiple characters can have same skill and can have multiple skills) (Some skills have prereqs)
    Player vs Player - each match has: score of each character, list of match history (only 2 players in match)
    Guild - name of guild, time created, current status, list of characters in guild

    Learn More
  8. DBM 261 Week 2 Access database Riordan Manufacturing

    DBM 261 Week 2 Database Creation Riordan Manufacturing

    Regular Price: $20.00

    Special Price: $15.00

    Create a Microsoft Access database using Riordan Manufacturing’s 2005 sales figures.

    Normalize the tables to the third normal form.

    Create relationships among tables using the relationship tool. These relationships must include settings for referential integrity and cardinality.

    Create an extended ERD of your newly created database, using
    Microsoft Word, PowerPoint, or Visio.

    Include primary keys, foreign keys, fields, relationships, and cardinality in the ERD. Learn More
  9. CTS2437 South Community College ERD

    CTS2437 South Community College ERD and SQL script

    Regular Price: $15.00

    Special Price: $12.00

    South Community College (SCC) is structured like a typical community college. They have 3 semesters and a multitude of courses. Each course may have any number of sections in a given semester. For example, CTS2437 (SQL Server) may have one or more sections being taught in any given semester. SCC has 3 semesters (fall, spring, summer) which they refer to as A, B, and C. They refer to semesters by the year and the semester code. For example, fall 2011 would be referred to as 2011A. They need to keep track of students, courses, schedules, instructors, and grades earned in each course taken. They need a database to maintain these information.
    The student information would include the student name, address, phone#, and email. Students may have taken or are taking any number of courses. The grade earned for each course must also be maintained. The course information would include the course title and number of credits. Keep in mind that a given course may have many sections in any particular semester. SCC needs to maintain the instructor for each section in addition to the students and the grade they earned. The instructor information would include the instructor name, phone#, office#, and email address. South needs to maintain all courses that the instructor has taught or is currently teaching.

    Some of the requirements that SCC has requested in the database system include:
    • Student cannot register for the same section more than once.
    • A roaster of students can be produced for any given section.
    • GPA (Grade Point Average) can be generated for a student for any given semester, year, or entire school career.
    • GPA is calculated by adding up all of the grades earned (A=4, B=3, C=2, D=1, F=0) and dividing by the number of credits associated with the courses taken.
    • A transcript can be produced for a given student showing all courses taken and grades earned.
    Learn More
  10. PCI Warranty Call Center ERD

    CIS 355 PCI Warranty Call Center Case ER Diagram

    Regular Price: $15.00

    Special Price: $12.00

    CIS 355 Term Project Part I

    For your term project, you are expected to design and implement a relational database to meet the requirements described in the PCI Warranty Call Center Case.

    Deliverables

    Part I - Project Design Document

    This document should have the following components:

    1. A conceptual ER model/diagram of PCI’s data requirements. The diagram should include all relevant entities, attributes and relationships. For each entity, specify the identifier (primary key). Specify relationship names and cardinality constraints. Indicate which attributes are required, composite, multi- valued, and/or derived (Note: by default, an attribute is assumed to be optional, simple, single-valued and not derived). Indicate which entities are associative. Follow consistent naming conventions for entities and attributes. Use modeling/diagramming software to create the ER Diagram.

    2. A list of the normalized relations (the logical model) and their attributes. For each relation, primary and foreign keys should be clearly indicated. Note: Use the format that we will be discussing in class for presenting your logical model.

    3. A list of assumptions (if any) made about the information requirements presented in the case. Note: the assumptions should be reasonable and should not contradict the facts of the case.

    4. A data dictionary that defines the metadata for the logical model. The data dictionary should include: the definition of each relation and attribute; the primary and foreign keys in each relation; attribute data types and lengths; and whether attributes are optional or required. Organize the data dictionary alphabetically by relation name.

    Assessment

    Part I deliverables will be evaluated based on the completeness and correctness/accuracy of the conceptual and logical data models, and of the supporting documentation (i.e., data dictionary, assumptions (if any)).

    If any of the deliverables are hand-drawn/written, your submission will not be graded. Submit the deliverables as one or more files. Include your name and title of the project on every page of the documents you submit. Learn More

Items 11 to 20 of 32 total

per page
Page:
  1. 1
  2. 2
  3. 3
  4. 4

Grid  List 

Set Ascending Direction