日本欧洲视频一区_国模极品一区二区三区_国产熟女一区二区三区五月婷_亚洲AV成人精品日韩一区18p

NZDITTS5代做、代寫SQL設計編程

時間:2024-05-31  來源:  作者: 我要糾錯



© Web Design and Database Application (Assessment 2) v2.1 Page 1 of 17 
 
School of Tech 
NZ Diploma in Informatton Technology Technical Support (Level 5) 
 
 Course Code & Title: IT504 Web Design and Database Applicatton 
Assignment Title Assessment 2 Assessment Type 
Database Applicatton 
Level 5 Credits 15 
Term & Cohort: 
Due date: 
Overall Weighttng: 50% 
Total marks available 100 
Tutor: 
 
Course aim 
This course provides students with the skills and knowledge to design and create robust websites 
implementtng HCI principles and usability tests to meet user requirements. Students will also learn 
the knowledge of database fundamentals and implement a database applicatton to solve business 
problems. 
 
Purpose 
The purpose of this assessment is to design a database solutton by implementtng data modelling 
principles and developing a database applicatton by implementtng the concepts of relattonal database. 
 
Learning Outcomes (LOs) 
This assessment is mapped to the following learning outcomes for this course: 
LO 4 Design a database solutton by applying data modelling principles. 
LO 5 Develop a database applicatton by implementtng the concepts of relattonal database. 
 
Graduate Proffle Outcomes (GPOs) 

Apply knowledge of database administratton and query languages to meet organisattonal 
data storage and retrieval requirements, including database management system (DBMS) 
opttmisatton, cleansing, security, and backups. 

Apply the fundamentals of informatton systems concepts and practtce, including business 
concepts, development life cycles, data modelling and administratton, to support and 
enhance organisattonal processes and systems. © NZSE – (NZDITTS5) IT504 Web Design and Database Application (Assessment 2) v2.1 Page 2 of 17 
 
Assessment Information 
• This is an individual open-book assessment. The assessment is worth 50% of your total 
assessment weighting of the entire course. 
• To achieve a pass in this assessment all tasks must be attempted. A minimum pass mark of 
50% for the assessment and meeting all the requirements for LO4 and LO5. 
• You must complete the Student Declaration and attestation on Canvas LMS. 
• You must submit your completed assessment to Canvas. 
• You must ensure you are familiar with NZSE’s academic policies regarding assessments, 
and the relevant resubmission regulations that apply to this course. These policies and 
regulations can be found on your Course Outline on Canvas LMS. 
• Your assessment will be marked on Canvas, and your assessment grade will be provided 
on Canvas too. 
• A maximum of 15% of the content may be quoted or paraphrased from other sources 
provided you acknowledge and cite the original source of material you use. 
• All cases of plagiarism and/or cheating will be investigated and dealt with according to A08: 
Misconduct in Assessment Policy. 
 
Submission Instructions 
You are required to ensure you have carried out the following before submitting your assessment: 
• Assessments submitted online should use the following naming convention: 
o Course Code_ Assessment Number_ Assessment Name_ Student 
Number_Document number o For example, 
IT504_A2_DatabaseApplication_1800XXXX_1 
• All answers must be written in your own words. 
• Proofread and spell check all written assessment work carefully. 
• DO NOT email your document to your tutor, it must be uploaded to the NZSE LMS 
• Check that all evidence required has been uploaded to the link provided on the NZSE LMS 
(Canvas). 
Plagiarism 
• All cases of plagiarism and/or cheating will be investigated and dealt with according to A08: 
Misconduct in Assessment Policy. 
 © NZSE – (NZDITTS5) IT504 Web Design and Database Application (Assessment 2) v2.1 Page 3 of 17 
Assessment Scenario 
You are working for a company called Maximum Velocity Cars as a Junior IT technician. Maximum Velocity 
Cars is a car rental company whose Headquarters is based on Queen Street, Auckland, New Zealand. The 
company opens from 6 am until 10 pm every day and has twenty-eight employees working on a shift basis 
to cater for customers during opening hours. 
The owner of the company, Mr Archer has asked you to create a Database to help his company keep track of 
all the cars that are available to rent or are rented. He would also like the destination to be included so pick 
up of cars can be arranged at noncompany drop-off points. 
Your task is to create a database file by using the following information: 
• CarFleet Table: 
o CarID (AutoNumber) 
o CarManufacturer 
o CarModel 
o CarBodyStle 
o CarFuelType 
o CarTransmission 
o CarReleaseYear 
o CarNumberofSeats 
o CarColour 
o CarLicensePlate 
o CarRentalPrice 
 
• Company Table: 
o CompanyID 
o CompanyBranchName 
o CompanyLocation 
o CompanyPhone 
o CompanyEmail 
 
• Rental Table: 
o RentalID 
o RentalCustomerID 
o RentalCarID 
o RentalPickupID 
o RentalDays 
o RentalTotalCost 
 
• Customer Table: 
o CustomerID 
o CustomerFirstName 
o CustomerLastName 
o CustomerPhone 
o CustomerEmail 
o CustomerDrivingLicense 
o CustomerPassport (If international) 
o CustomerNextofKin 
o CustomerNextofKinContactNumber © NZSE – (NZDITTS5) IT504 Web Design and Database Application (Assessment 2) v2.1 Page 4 of 17 
 
 
Note: Take screenshots to show the various steps taken to produce the final database application and 
screenshots of the SQL query statements used with query output. 
 
Assessment Tasks: Database application creation (100 Marks) 
LO 4: Design a database solution by applying data modelling principles. 
LO 5: Develop a database application by implementing the concepts of relational database. 
 
1. Based on the scenario, design an Entity Relationship Diagram (ERD) by following the steps below: 
a. use Crow’s foot or Chen notation.; (LO4) (5 marks) 
b. contains (LO4) (15 marks) 
• all the entities, (max 4 marks) 
• it’s attributes (max 6 marks) 
• and their relationships; (max 5 marks) 
c. Implement (LO4) (10 marks) 
• primary keys, (max 4 marks) 
• foreign keys, (max 3 marks) 
• cardinality constraints(max 3 marks) 
2. Perform a normalisation in continuation with the ER diagram. (LO4) (16 marks) 
a. Apply 1NF and translate: (6 marks) 
• Convert all entities into tables (max 2 marks) 
• Transform all attributes into columns (max 2 marks) 
• Apply correct data types (max 2 marks). 
b. Apply 2NF upon 1NF and eliminate partial dependencies. This must include: (10 marks) 
• Converting all entities into tables (max 2 marks) 
• Transforming all attributes into columns (max 2 marks) 
• Applying correct data types (max 2 marks). 
• Providing valid relationships with primary and foreign keys. (max 4 marks) 
 
3. Build the database based on the normalisation. This must include: (LO5) (10 Marks) 
a) Query to create database. (max 2 marks) 
b) All tables based on 2NF (max 4 marks) 
c) Correct fields in each table (max 2 marks) 
d) Correct datatypes for each field (max 2 marks) 
4. Populate (minimum 10 rows need to be populated for each table). (LO5) (8 Marks) 
5. Create a query, in design view, which will extract the Customer name and contact details (phone and 
email), make and model of the car, and the number of days they have rented the car for. (LO5) 
 (5 Marks) © NZSE – (NZDITTS5) IT504 Web Design and Database Application (Assessment 2) v2.1 Page 5 of 17 
6. Design and create three (3) forms, showing the following tables, Customers, Car Fleet and Rental 
tables. (LO5) (3 Marks) 
7. Generate a report, showing the output from the query created in task 5, include the company name 
in the heading, and the date report was generated. (LO5) (5 Marks) 
8. Show two ways to enhance and optimise the database. (LO5) (4 Marks) 
9. Create a backup of the database. Please provide evidence, such as screenshots, and also include the 
backup file (LO5) (2 Marks) 
10. Set up a strong password for the database with a minimum of 16 characters, including numbers, 
alphabets, and special characters. Additionally, suggest another method of securing the 
database.(LO5) (5 Marks) 
11. Create queries: 
a. Use the SELECT SQL statement to query data from different COLUMNS (RentalCarID, 
RentalCustomerID and RentalDays) but from the same TABLE (Rental Table) (LO5) (2 marks) 
b. Use the WHERE SQL clause to filter records using a condition (CarFuelType is petrol). (LO5) 
 (2 marks) 
c. Use the NOT SQL operator to create a query to filter the date (CarReleaseYear) based on a 
certain condition (the condition is up to the student). (LO5) (2 marks) 
d. Use the AND SQL operator to create a query to filter the date (CarReleaseYear) based on a 
certain condition (the condition is up to the student). (LO5) (2 marks) 
e. Use the ORDER BY SQL keyword to sort the result-set for CustomerLastName in ascending 
order. (LO5) (2 marks) 
f. Use the MIN() SQL function to return the smallest value from the RentalTotalCost column. 
(LO5) (2 marks) 
 
 
 
Note: Check the marking rubric on pages 8-14 for the mark allocation and guidelines to ensure you gain 
optimum marks. 
 
 
 © NZSE – (NZDITTS5) IT504 Web Design and Database Application (Assessment 2) v2.1 Page 6 of 17 
 
 
 School of Tech 
NZ Diploma in Information Technology Technical Support (Level 5) 
Cover Sheet and Student Declaration 
This sheet must be signed by the student and attached to the submitted assessment. 
Course Title: 
Web Design and Database 
Application 
Course code: IT504 
Student Name: Student ID: 
Assessment No 
& Type: 
Assessment 2 
Database Application 
Cohort: 
Due Date: 
Date 
Submitted: 
 
Tutor’s Name: 
 
Assessment 
Weighting 
50% 
 
Total Marks 100 
 
 
Student Declaration: 
 
I declare that: 
• I have read the New Zealand School of Education Ltd policies and regulations on assessments and 
understand what plagiarism is. 
• I am aware of the penalties for cheating and plagiarism as laid down by the New Zealand School 
of Education Ltd. 
• This is an original assessment and is entirely my own work. 
• Where I have quoted or made use of the ideas of other writers, I have acknowledged the source. 
• This assessment has been prepared exclusively for this course and has not been or will not be 
submitted as assessed work in any other course. 
• It has been explained to me that this assessment may be used by NZSE Ltd, for internal and/or 
external moderation. 
 
Student signature: 
Date: 
 © NZSE – (NZDITTS5) IT504 Web Design and Database Application (Assessment 2) v2.1 Page 7 of 17 
 
Tutor only to complete 
 
Assessment result: Mark /100 Grade 
LO4 Requirements 
Achieved ☐ 
Not Achieved ☐ 
Tutor Signature 
LO5 Requirements 
Achieved ☐ 
Not Achieved ☐ 
 © NZSE – (NZDITTS5) IT504 Web Design and Database Application (Assessment 2) v2.1 Page 8 of 17 
 
 
IT504 - Web Design and Database Application 
Assessment 2 - Assessment Marking Rubrics 
LO 4: Design a database solution by applying data modelling principles. 
LO 5: Develop a database application by implementing the concepts of relational database. 
Criteria 
 LO 4: Design a database solution by applying data modelling principles. 
1. ER 
Diagram 
 
(LO4) 
1a. 
(5 marks) 
Student created ERD using a 
professional tool (crow’s foot 
/Chen’s notation) 
 
 
 (5 marks) 
Student created ERD using a 
professional tool with minor 
mistakes (crow’s foot /Chen’s 
notation) or vice-versa. 
 
(3-4 marks) 
Student created ERD using a 
professional tool with major 
mistakes (crow’s foot /Chen’s 
notation) or vice-versa. 
 
(1 -2 marks) 
Student did not create ERD using any 
professional tool. 
 
 
 
(0 marks) 
1b 
 
(15 marks) 
Student has correctly created the ER Diagram based on the given scenario that included the requirements of 
the ERD: 
1. Four (4) entities (max 4 marks, 1 mark per entity) 
2. Thirty (30) attributes (max 5 marks, 1 mark per 6 attributes) 
3. Three (3) relationships (max 6 marks, 2 marks per relationship) 
 
 
 (1 - 15 marks) 
Student did not include any of following in 
ERD correctly. 
1. entities 
2. attributes 
3. relationship 
 
 (0 marks) 
1c 
(10 marks) 
Student has correctly implemented the requirements of the ERD specified below: 
1. Four (4) primary Keys (max 4 marks, 1 mark per primary key) 
2. Three (3) foreign keys (max 3 marks, 1 mark per foreign key) 
3. Three (3) cardinality constraints (max 3 marks, 1 mark per cardinality constraints) 
 
 
 (1 - 10 marks) 
Student did not include any of following in 
ERD correctly. 
1. Primary keys 
2. foreign keys 
3. cardinality constraints 
 
(0 marks) 
2. Normalisation 
(16 marks) 
(LO4) 
Student has correctly applied the 1NF and translated the following: 
 
1. All entities into tables (max 2 marks, 1 mark per 2 tables) 
2. All attributes into columns (max 2 marks, 1 mark per 15 columns) 
3. Applied correct data types (max 2 marks, 1 mark for correct datatype on 15 columns ). 
 
(1 – 6 marks) 
Student did not apply 1NF. 
 
 
 
 
(0 marks) © NZSE – (NZDITTS5) IT504 Web Design and Database Application (Assessment 2) v2.1 Page 9 of 17 
 
 
Student has correctly applied the 2NF upon 1NF and eliminated partial dependencies as well as included the 
following: 
 
1. Converted all entities into tables (max 2 marks, 1 mark per 2 tables) 
2. Transformed all attributes into columns (max 2 marks, 1 mark per 15 columns) 
3. Applied correct data types (max 2 marks, 1 mark for correct datatype on 15 columns). 
4. Provided valid relationships with primary and foreign keys. (max 4 marks, 1 mark for correct relationship) 
 
(1 – 10 marks) 
 
Student did not apply 2NF. 
 
 
 
 
 
(0 marks) 
 
 
LO 5: Develop a database application by implementing the concepts of relational database. 
3. Database 
creation 
(10 Marks) 
(LO5) 
Student has correctly built the database and included the following: 
 
1. Query to create database. (max 2 marks) 
2. All tables based on 2NF (max 4 marks, 1 mark per table) 
3. Correct fields in each table (max 2 marks, 1 mark per 2 tables correct fields) 
4. Correct datatypes for each field (max 2 marks, 1 mark per 2 tables datatypes) 
 
 (1 - 10 marks) 
Student has not provided evidence of creating and populating any of the 
tables in the database as per a given scenario. 
 
 
 
 
(0 marks) 
4. Populate 
tables 
(8 Marks) 
(LO5) 
Student has populated ALL tables and included: 
1. 10 or more rows in a table (max 2 marks) 
2. 6 to 9 rows in a table (max 1 mark) 
3. 5 or fewer rows in a table (0 marks) 
 
(1 - 8 marks) 
Student has populated all tables but has fewer than 5 rows in each 
table. 
 
 
 (0 marks) 
5. Create a 
query in 
design 
view 
(5 Marks) 
(LO5) 
Student has correctly 
created a query that can 
extract ALL of the 
following required fields 
from multiple tables. 
1. Phone Number (max 
1 mark) 
2. Email (max 1 mark) 
3. Car Make 
(manufacturer) (max 
1 mark) 
Student has correctly 
created a query but can 
extract only four (4) 
required fields mentioned 
from the below required 
fields from multiple 
tables. 
1. Phone Number (max 
1 mark) 
2. Email (max 1 mark) 
Student has correctly 
created a query but can 
extract only three (3) 
required fields mentioned 
from the below required 
fields from multiple 
tables. 
1. Phone Number (max 1 
mark) 
2. Email (max 1 mark) 
Student has correctly 
created a query but can 
extract only two (2) 
required fields mentioned 
from the below required 
fields from multiple 
tables. 
1. Phone Number (max 1 
mark) 
2. Email (max 1 mark) 
Student has correctly 
created a query but can 
extract only one (1) 
required fields mentioned 
from the below required 
fields from multiple 
tables. 
1. Phone Number (max 
1 mark) 
2. Email (max 1 mark) 
 Student has not created 
the query required. 
 
 
 
 
 
 
 © NZSE – (NZDITTS5) IT504 Web Design and Database Application (Assessment 2) v2.1 Page 10 of 17 
 
 
4. Car Model (max 1 
mark) 
5. Number of days 
(Rental days) (max 1 
mark) 
 
 
 
 
(5 marks) 
3. Car Make 
(manufacturer) (max 
1 mark) 
4. Car Model (max 1 
mark) 
5. Number of days 
(Rental days) (max 1 
mark) 
 
(4 marks) 
3. Car Make 
(manufacturer) (max 1 
mark) 
4. Car Model (max 1 
mark) 
5. Number of days 
(Rental days) (max 1 
mark) 
 
(3 marks) 
3. Car Make 
(manufacturer) (max 1 
mark) 
4. Car Model (max 1 
mark) 
5. Number of days 
(Rental days) (max 1 
mark) 
 
(2 marks) 
3. Car Make 
(manufacturer) (max 
1 mark) 
4. Car Model (max 1 
mark) 
5. Number of days 
(Rental days) (max 1 
mark) 
 
(1 marks) 
 
 
 
 
 
 
(0 marks) 
6. Create 3 
Forms 
(3 Marks) 
(LO5) 
Student has created all three (3) Forms. 
 
 
(3 marks) 
Student has created two (2) Forms. 
 
 
(2 marks) 
Student has created one (1) Form. 
 
 
(1 mark) 
Student HAS NOT created 
any forms. 
 
(0 marks) 
7. Create report 
(5 Marks) 
(LO5) 
Student has generated a 
report with correct format 
that: 
• Shows the output 
from query created 
in task 5, (max 3 
marks) 
• Includes the 
company name in the 
header, (max 1 
marks) 
• Includes the date the 
report was generated 
in a visible location. 
(max 1 marks). 
 
 
 
 
 
 
(5 marks) 
Student has generated a 
report with correct format 
that: 
 
Shows the output from 
query created in task 5, 
(max 3 marks) 
 
BUT 
 
Does not include the 
company name in the 
header (max 1 marks). 
 
OR 
 
Does not include the date, 
the report was generated 
in a visible location. (max 
1 marks). 
 
(4 marks) 
 Student has generated a 
report with correct format 
that: 
 
Shows the output from 
query created in task 5, 
(max 3 marks) 
 
BUT 
 
Does not include the 
company name in the 
header (max 1 marks). 
 
AND 
 
Does not include the date, 
the report was generated 
in a visible location. (max 
1 marks). 
 
 
(3 marks) 
Student has generated a 
report with correct format 
that: 
 
Does not show the output 
from query created in task 
5, (max 3 marks) 
 
BUT 
 
Does include the company 
name in the header (max 
1 marks). 
 
AND 
 
Does include the date, the 
report was generated in a 
visible location. (max 1 
marks). 
 
 
(2 marks) 
Student has generated a 
report with correct format 
that: 
 
Does not show the output 
from query created in task 
5, (max 3 marks) 
 
BUT 
 
Does include the company 
name in the header (max 
1 marks). 
 
OR 
 
Does include the date, the 
report was generated in a 
visible location. (max 1 
marks). 
 
 
(1 mark) 
Student has not 
attempted to create the 
report. 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
(0 marks) © NZSE – (NZDITTS5) IT504 Web Design and Database Application (Assessment 2) v2.1 Page 11 of 17 
 
 
8. Optimise 
Database 
(4 Marks) 
(LO5) 
Student has correctly shown two ways to enhance and 
optimise the database. 
 
 
(3 – 4 marks) 
Student has correctly shown only ONE way to enhance and optimise the 
database. 
 
 
(1-2 marks) 
Student has not 
attempted the task. 
 
 
 (0 marks) 
9. Backup 
Database 
(2 Marks) 
(LO5) 
Student has created a backup of the database and provided ALL the 
following: 
1. Backup file (max 1 mark) 
2. Screenshot of the database backup process(max 1 mark) 
 
 
(2 marks) 
Student has created a backup of the database but provided either. 
1. Backup file (max 1 mark) 
OR 
 2. Screenshot of the database backup process(max 1 mark) 
 
 
(1 Mark) 
 Student has not 
created a backup of the 
database. 
 
 
(0 marks) 
10. Apply security 
to database 
(5 Marks) 
(LO5) 
Student has set up a strong password with: 
 
1. A minimum of 16 characters (max 1 mark) 
2. Password includes numbers, alphabets, and special characters 
(max 2 marks) 
3. AND provided another way of securing the database (max 2 
marks) 
 
(4 – 5 marks) 
Student has set up a strong password with: 
1. A minimum of 16 characters (max 1 mark) 
2. Password includes numbers, alphabets, and special 
characters (max 2 marks) 
 
BUT NOT provided another way of securing the database (max 2 
marks) 
 
(1 – 3 marks) 
Student has NOT set 
up a strong password 
AND NOT provide at 
least 1 other way of 
securing the database. 
 
(0 marks) 
11. Create Queries 
(12 Marks) 
 
(LO5) 
using Select 
SQL 
(2 Marks) 
 Student has provided evidence of query using the correct SELECT 
SQL command to show the required output. 
 
(2 marks) 
Student has provided evidence of query using SELECT SQL 
command, but the output is incorrect. 
 
(1 mark) 
Student has not 
attempted the task. 
 
(0 marks) 
using WHERE 
SQL 
(2 Marks) 
 Student has provided evidence of query using the correct WHERE 
SQL command to show the required output. 
 
(2 marks) 
Student has provided evidence of query using WHERE SQL 
command, but the output is incorrect. 
 
(1 mark) 
Student has not 
attempted the task. 
 
(0 marks) 
using NOT 
SQL 
(2 Marks) 
 Student has provided evidence of query using the correct NOT SQL 
command to show the required output. 
 
(2 marks) 
Student has provided evidence of query using NOT SQL 
command, but the output is incorrect. 
 
 (1 mark) 
Student has not 
attempted the task. 
 
 (0 marks) © NZSE – (NZDITTS5) IT504 Web Design and Database Application (Assessment 2) v2.1 Page 12 of 12 
 
 
using AND 
SQL 
 (2 marks) 
 Student has provided evidence of query using the correct AND SQL 
command to show the required output. 
 
(2 marks) 
Student has provided evidence of query using AND SQL 
command, but the output is incorrect. 
請加QQ:99515681  郵箱:99515681@qq.com   WX:codinghelp









 

標簽:

掃一掃在手機打開當前頁
  • 上一篇:代做UIC's finance office.、代寫java編程語言
  • 下一篇:3809ICT代寫、Python/Java程序代做
  • 無相關信息
    昆明生活資訊

    昆明圖文信息
    蝴蝶泉(4A)-大理旅游
    蝴蝶泉(4A)-大理旅游
    油炸竹蟲
    油炸竹蟲
    酸筍煮魚(雞)
    酸筍煮魚(雞)
    竹筒飯
    竹筒飯
    香茅草烤魚
    香茅草烤魚
    檸檬烤魚
    檸檬烤魚
    昆明西山國家級風景名勝區
    昆明西山國家級風景名勝區
    昆明旅游索道攻略
    昆明旅游索道攻略
  • NBA直播 短信驗證碼平臺 幣安官網下載 歐冠直播 WPS下載

    關于我們 | 打賞支持 | 廣告服務 | 聯系我們 | 網站地圖 | 免責聲明 | 幫助中心 | 友情鏈接 |

    Copyright © 2025 kmw.cc Inc. All Rights Reserved. 昆明網 版權所有
    ICP備06013414號-3 公安備 42010502001045

    日本欧洲视频一区_国模极品一区二区三区_国产熟女一区二区三区五月婷_亚洲AV成人精品日韩一区18p

              欧美日韩日本国产亚洲在线 | 欧美福利视频| 欧美性猛交一区二区三区精品| 一本久久a久久精品亚洲| 欧美黑人一区二区三区| 亚洲欧美一区二区三区极速播放 | 免费日韩成人| 欧美夜福利tv在线| 一区二区三区欧美视频| 在线观看91精品国产麻豆| 欧美三级欧美一级| 久久综合中文字幕| 性欧美暴力猛交另类hd| 一本大道久久a久久精二百| 亚洲第一综合天堂另类专| 国产精品v日韩精品| 欧美精品免费在线观看| 久久久久久69| 久久福利影视| 欧美一区二区日韩| 亚洲尤物在线视频观看| 99re6热在线精品视频播放速度| 精品福利av| 激情成人av| 国产伊人精品| 狠狠色综合网| 激情综合色丁香一区二区| 国内精品模特av私拍在线观看| 国产精品入口夜色视频大尺度| 欧美日韩中文另类| 欧美视频中文字幕在线| 欧美视频中文字幕在线| 欧美视频导航| 国产精品久久久久久久午夜| 欧美日韩日日夜夜| 国产精品免费电影| 国产一区999| 精品9999| 亚洲二区在线视频| 日韩视频在线一区| 亚洲一区高清| 久久精品亚洲热| 欧美xx视频| 欧美日韩亚洲91| 国产欧美精品久久| 在线播放亚洲| 一区二区三区欧美视频| 小处雏高清一区二区三区| 久久久久.com| 欧美日韩国产一级| 国产欧美韩日| 亚洲国产精品t66y| 亚洲一区二区三区在线| 久久精品免费电影| 欧美日本不卡高清| 国产日本欧美视频| 亚洲日本电影| 欧美一区二区三区视频在线| 久久久一二三| 国产精品大片免费观看| 国产一区二区久久精品| 日韩视频在线观看免费| 欧美在线免费观看亚洲| 欧美成人免费网站| 国产精品永久免费视频| 亚洲电影中文字幕| 亚洲欧美一区二区激情| 欧美在线亚洲在线| 欧美日韩久久不卡| 亚洲国产99精品国自产| 亚洲专区一区| 欧美乱大交xxxxx| 国产日产亚洲精品| 在线视频免费在线观看一区二区| 久久蜜桃精品| 国产精品入口夜色视频大尺度| 在线观看欧美成人| 欧美伊人久久久久久久久影院 | 免费日韩成人| 国精品一区二区| 亚洲在线视频观看| 欧美日本在线看| 在线精品视频在线观看高清| 欧美一区二区三区视频免费| 欧美午夜在线视频| 亚洲狼人综合| 欧美成人中文| 亚洲国产精品尤物yw在线观看| 欧美影视一区| 国产欧美精品久久| 欧美一区二区大片| 国产精品久久久久婷婷| 中日韩美女免费视频网站在线观看| 蜜臀av在线播放一区二区三区| 国内外成人免费激情在线视频网站| 一本久道久久久| 欧美日本韩国一区| 亚洲精品一区二区三区四区高清| 久久亚洲影音av资源网| 一区二区三区亚洲| 久久人91精品久久久久久不卡| 国产欧美精品在线观看| 欧美亚洲一级| 黄色成人片子| 老司机凹凸av亚洲导航| 亚洲欧洲三级| 欧美色图麻豆| 欧美一区成人| 精品不卡在线| 欧美激情第五页| 在线视频你懂得一区| 国产精品视频xxx| 久久精品三级| 亚洲第一色在线| 欧美日韩精品一本二本三本| 一区二区三区黄色| 国产区精品视频| 久久影院午夜片一区| 亚洲国产电影| 国产精品福利在线| 欧美专区日韩专区| 亚洲国产精品美女| 欧美亚一区二区| 久久免费视频一区| 一本色道久久| 激情久久五月| 国产精品成人一区二区三区夜夜夜| 午夜精品福利视频| 亚洲黄色天堂| 国产精品视频最多的网站| 另类春色校园亚洲| 亚洲一区二区三| 亚洲第一综合天堂另类专| 国产精品久久综合| 蜜乳av另类精品一区二区| 国产精品99久久久久久久女警| 国产一区视频观看| 国产精品大片免费观看| 麻豆精品视频在线| 午夜久久tv| 一本色道久久综合狠狠躁篇怎么玩| 国产午夜精品美女毛片视频| 欧美—级高清免费播放| 久久久久久网址| 欧美一区二区三区免费视| 亚洲人成网站在线观看播放| 国产欧美91| 国产精品美女| 欧美日韩成人一区二区| 久久精品女人的天堂av| 一本色道久久加勒比88综合| 欧美日韩国产欧| 亚洲综合视频网| 在线观看成人av电影| 国产精品久久久久久超碰| 美女精品国产| 欧美一级大片在线免费观看| 韩曰欧美视频免费观看| 国产精品亚洲第一区在线暖暖韩国 | 玉米视频成人免费看| 欧美性事免费在线观看| 免播放器亚洲一区| 欧美一区二区三区精品电影| 一区二区视频欧美| 一区二区三区在线观看视频| 国产精品美女一区二区| 欧美精品午夜| 欧美一区二区三区免费观看视频| 亚洲精品国产日韩| 亚洲电影下载| 亚洲福利国产| 亚洲免费电影在线| 最新亚洲一区| 亚洲精品国产精品乱码不99| 激情亚洲网站| 一区二区亚洲欧洲国产日韩| 国产乱码精品一区二区三区忘忧草| 欧美精品免费观看二区| 久久综合九色综合久99| 久久色在线播放| 久久久99国产精品免费| 欧美伊人久久久久久久久影院| 性做久久久久久免费观看欧美 | 亚洲国产激情| 亚洲国产精品一区制服丝袜| 亚洲成人原创| 99视频一区二区三区| 亚洲国产小视频在线观看| 亚洲人成网站色ww在线| 亚洲精品乱码久久久久久| 亚洲亚洲精品三区日韩精品在线视频| 99国产一区| 亚洲欧美日本精品| 久久久久久久成人| 美女国产一区| 欧美日韩国产一区| 欧美日韩国产二区| 国产精品毛片在线| 国产欧美精品日韩区二区麻豆天美| 国产乱肥老妇国产一区二|