这是一门新西兰的编程代写网课代上，介绍编程语言的设计和实现，包括语言特性、范式和设计决策。 简要介绍功能和逻辑编程范式并强化面向对象的概念。 讨论解释器、编译器、transpires 和虚拟机，包括词法分析、解析、语义分析、优化、代码生成。 自动机和状态机简介。 CoursePear Python代写 @2009。

Part A Entity Relationship Modelling and Logical Database Design (35 marks)

Task 1 Identify Entities & Develop Business Rules [10 marks]

Identify all entities and relationships in the case study and develop a set of business rules. You should follow the syntax given below. Two rules must describe each relationship, one in each direction.

Each/A/An ENTITY_1 May/Must Relationship_Verb_Phrase number ENTITY_2

Task 2 Construct a logical Entity Relationship Diagram (ERD) [25 marks]

Based on the business rules developed in Task 1, construct a logical ERD for the case study using the Visual Paradigm tool.

  • Identify all attributes in each entity, including all primary and foreign keys (transform any composite and multivalued attributes according to the rules of the relational model).
    • Name all relationships (i.e. you must use verb phrases on both sides of each relationship)
    • Identify the Cardinality and Participation for each relationship.
    • Resolve all many to many (M:N) relationships.
    • Describe any assumptions you have made in a text note on the diagram.

Please note:

  1. You don’t need to identify data types in your ERD.
  2. You don’t need to answer task 2 questions separately. You identify them on the diagram.

Part B Database Implementation (35 marks)

In this part, you should develop a database based on your logical ERD developed in Part A. You must populate the tables with realistic sample data.

Task 3 Create tables [25 marks]

Create the tables in Oracle.1 Write SQL scripts defining each table. The table definitions should include

  • All attributes with appropriate data types
    • All appropriate constraints such as primary key, foreign keys, and check statements (CHECK constraints).
    • All constraints must be given names. Naming standards must be used.

Task 4 Populate data [10 marks]

Insert a small sample of realistic test data (5 –10 rows minimum) into each table. All test data must be meaningful to demonstrate your understanding of the data.

After creating all your tables (Task 3) and inserting data (Task 4), run the SQL SELECT statement below:

SELECT table_name FROM user_tables;

The statement will retrieve a list of all tables that exist in your Oracle account (i.e., all tables you created). Include the results of the SELECT statement in your assignment.

You must also include the following for each table in your database:

  • SQL table creation script
    • SQL insert script (used for inserting sample data)
    • Sample data – you must run “SELECT * FROM table_name” (where table_name is the name of the table) for each of your tables in Task 3 and include results of SELECT statements for each table.

1 You must use Oracle SQL Developer for Parts B and C.

Part C Construct SQL Queries (30 marks)

Task 5 Construct SQL Queries [30 marks]

Identify five data retrieval requirements that would be used by the business described in the case study. For each requirement you have identified, construct a SQL query needed to display the data. So, you must construct five SQL queries in total. The queries must include a combination of the following SQL features:

  • Use of restriction (WHERE clause), Arithmetic expressions, Concatenation of columns
    • Use of comparison and logical operators
    • Multiple tables join (e.g., Equijoin, Outer Join, and Self-join)
    • Group functions (e.g., COUNT, SUM, AVG, MAX, MIN) and clauses (e.g., ORDER BY, GROUP BY, HAVING)

Note:

  1. You may combine the preceding features in a single query. The design of each query should demonstrate your knowledge and application of SQL content covered in the course and understanding of the correct usage of the various features and clauses of SQL. A simple ‘select * from table_name’ will fetch you a mark of zero.
  • There should be no more than one query that involves a single table.
  • An example of a query is given on the next page.
Staff NoStaff NameQualification
101John SmithBSc
212Mike BirdBSc
112Susan CarrBSc
117David CameronBSc

For Part C, you must include the following (as shown above) for each SQL query statement:

  • Description of the purpose of the query.
    • SQL SELECT query
    • The result of the query

2 Please note that this is an example from a different database that is not related to your assignment.

TaskMarking CriteriaMax Mark
Part A Entity Relationship Modelling and Logical Database Design
Part A – Task 1Identify Entities & Develop Business RulesCover all the essential requirements from the case studyUses correct syntax for business rules10
Part A – Task 2Construct a logical Entity Relationship DiagramIdentify all attributes in each entity, including all primary and foreign keysMapping rules applied (any composite and multivalued attributes must be transformed).Name all relationships using verb phrasesIdentify Cardinality and Participation for each relationship.Resolve all many-to-many (M:N) relationships.Includes any assumptions, if any.25
Part A Total35
Part B Database Implementation
Part B – Task 3Oracle Table Creation Scripts for all tables in the database correct identification and definition of all attributes and relationshipsincludes the correct definition of all primary and foreign key constraints from the ERDuses consistent naming conventions for all table and attribute names, constraints (constraints are named), and appropriate data types.List of tables in your account25
Part B – Task 4Oracle Insert Scripts for populating the tables in your database: Insert statements along with sample realistic test Datathe results of SELECT statements: you must run “SELECT * FROM table_name” (where table_name is the table’s name) for each table in Task 3 and include the results of SELECT statements for each table.10
Part B Total35
Part C Construct SQL Queries
Part C – Task 5Construct five SQL Queries: Each queryRetrieves meaningful information to support the data and transaction requirements of the case studyeach query is distinct and significantly different from one anotherincludes a description of the purpose of the queryDemonstrates knowledge and application of SQL content covered in the course (covers important SQL features, clauses, and functions)Use of restriction (WHERE clause), Arithmetic expressions, Concatenation of columnsUse of comparison and logical operatorsMultiple table join (e.g. Equijoin, Outer-join, and Self- join)Group functions (e.g., COUNT, SUM, AVG, MAX, MIN) and clauses (e.g., ORDER BY, GROUP BY, HAVING)includes results (output rows) Note:You may combine some of the preceding features in a single query. The design of each query should demonstrate your understanding of the correct usage of the various features and clauses of SQL.A simple ‘select * from table_name’ will fetch you a zero mark.There should be no more than one query that involves a single table30
Part C Total30
Total of Parts A, B, and C100

CoursePear™是一家服务全球留学生的专业代写。
—-我们专注提供高质靠谱的美国、加拿大、英国、澳洲、新西兰代写服务。
—-我们专注提供Essay、统计、金融、CS、经济、数学等覆盖100+专业的作业代写服务。

编程代写
编程代写

CoursePear™提供各类学术服务，Essay代写，Assignment代写，Exam / Quiz助攻，Dissertation / Thesis代写，Problem Set代做等。